1 Convert csv to json

2 load library

library("jsonlite")
library("dplyr")
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union

3 Data

3.1 read csv

exif <- read.csv("./data/2022-04-14-MtDouglas-Exif.csv")
exif
##            SourceFile    DateTimeOriginal GPSLongitude GPSLatitude ExposureTime
## 1        DSCN7961.JPG 2022:04:14 14:21:41           NA          NA 0.0020000000
## 2        DSCN7962.JPG 2022:04:14 14:21:47           NA          NA 0.0020000000
## 3        DSCN7963.JPG 2022:04:14 14:21:54           NA          NA 0.0020000000
## 4        DSCN7965.JPG 2022:04:14 14:50:57    -123.3453    48.49260 0.0025000000
## 5        DSCN7966.JPG 2022:04:14 14:51:05    -123.3452    48.49255 0.0025000000
## 6        DSCN7967.JPG 2022:04:14 14:51:11    -123.3452    48.49252 0.0025000000
## 7        DSCN7968.JPG 2022:04:14 14:51:13    -123.3452    48.49252 0.0025000000
## 8        DSCN7969.JPG 2022:04:14 14:51:15    -123.3452    48.49256 0.0025000000
## 9   DSCN7970 copy.JPG 2022:04:14 14:51:16    -123.3452    48.49258 0.0025000000
## 10       DSCN7970.JPG 2022:04:14 14:51:16    -123.3452    48.49258 0.0025000000
## 11       DSCN7971.JPG 2022:04:14 14:52:28    -123.3454    48.49294 0.0200000000
## 12       DSCN7973.JPG 2022:04:14 14:52:30    -123.3454    48.49294 0.0200000000
## 13       DSCN7975.JPG 2022:04:14 14:52:41    -123.3453    48.49288 0.0080000000
## 14       DSCN7977.JPG 2022:04:14 14:53:54    -123.3454    48.49312 0.0125000000
## 15       DSCN7978.JPG 2022:04:14 14:54:26    -123.3455    48.49312 0.0020000000
## 16       DSCN7979.JPG 2022:04:14 14:54:29    -123.3454    48.49313 0.0100000000
## 17       DSCN7980.JPG 2022:04:14 14:54:42    -123.3455    48.49312 0.0080000000
## 18       DSCN7982.JPG 2022:04:14 14:54:58    -123.3456    48.49306 0.0166666667
## 19       DSCN7983.JPG 2022:04:14 14:55:04    -123.3456    48.49303 0.0333333333
## 20       DSCN7984.JPG 2022:04:14 14:55:09    -123.3457    48.49317 0.0333333333
## 21       DSCN7985.JPG 2022:04:14 14:55:12    -123.3457    48.49321 0.0250000000
## 22       DSCN7987.JPG 2022:04:14 14:56:31    -123.3454    48.49302 0.0062500000
## 23       DSCN7988.JPG 2022:04:14 14:56:33    -123.3456    48.49297 0.0062500000
## 24       DSCN7989.JPG 2022:04:14 14:56:36    -123.3456    48.49303 0.0050000000
## 25       DSCN7991.JPG 2022:04:14 14:56:47    -123.3456    48.49305 0.0040000000
## 26       DSCN7992.JPG 2022:04:14 14:57:21    -123.3456    48.49316 0.0250000000
## 27       DSCN7999.JPG 2022:04:14 14:58:25    -123.3457    48.49313 0.0166666667
## 28       DSCN8000.JPG 2022:04:14 14:58:27    -123.3457    48.49311 0.0200000000
## 29       DSCN8002.JPG 2022:04:14 14:58:35    -123.3456    48.49307 0.0200000000
## 30       DSCN8004.JPG 2022:04:14 14:58:53    -123.3456    48.49305 0.0200000000
## 31       DSCN8005.JPG 2022:04:14 14:59:07    -123.3456    48.49307 0.0166666667
## 32       DSCN8006.JPG 2022:04:14 14:59:16    -123.3456    48.49316 0.0166666667
## 33       DSCN8007.JPG 2022:04:14 14:59:17    -123.3456    48.49314 0.0166666667
## 34       DSCN8008.JPG 2022:04:14 15:00:58    -123.3457    48.49288 0.0020000000
## 35       DSCN8009.JPG 2022:04:14 15:01:04    -123.3457    48.49294 0.0015625000
## 36       DSCN8011.JPG 2022:04:14 15:01:37    -123.3456    48.49300 0.0025000000
## 37       DSCN8012.JPG 2022:04:14 15:01:40    -123.3456    48.49301 0.0025000000
## 38       DSCN8013.JPG 2022:04:14 15:01:56    -123.3457    48.49303 0.0050000000
## 39       DSCN8014.JPG 2022:04:14 15:02:51    -123.3458    48.49294 0.0010000000
## 40       DSCN8017.JPG 2022:04:14 15:03:24    -123.3458    48.49291 0.0008000000
## 41       DSCN8018.JPG 2022:04:14 15:03:25    -123.3458    48.49291 0.0012500000
## 42       DSCN8019.JPG 2022:04:14 15:03:26    -123.3458    48.49291 0.0012500000
## 43       DSCN8020.JPG 2022:04:14 15:03:42    -123.3458    48.49286 0.0015625000
## 44       DSCN8021.JPG 2022:04:14 15:04:05    -123.3458    48.49284 0.0012500000
## 45       DSCN8023.JPG 2022:04:14 15:04:31    -123.3458    48.49282 0.0025000000
## 46       DSCN8024.JPG 2022:04:14 15:04:46    -123.3458    48.49281 0.0012500000
## 47       DSCN8025.JPG 2022:04:14 15:04:47    -123.3458    48.49281 0.0015625000
## 48       DSCN8026.JPG 2022:04:14 15:06:58    -123.3460    48.49277 0.0025000000
## 49       DSCN8027.JPG 2022:04:14 15:07:27    -123.3457    48.49285 0.0031250000
## 50       DSCN8030.JPG 2022:04:14 15:07:58    -123.3457    48.49287 0.0008000000
## 51       DSCN8031.JPG 2022:04:14 15:08:37    -123.3457    48.49283 0.0012500000
## 52       DSCN8032.JPG 2022:04:14 15:08:42    -123.3457    48.49283 0.0012500000
## 53       DSCN8034.JPG 2022:04:14 15:09:19    -123.3457    48.49283 0.0012500000
## 54       DSCN8036.JPG 2022:04:14 15:09:21    -123.3457    48.49283 0.0025000000
## 55       DSCN8038.JPG 2022:04:14 15:09:25    -123.3457    48.49283 0.0025000000
## 56       DSCN8039.JPG 2022:04:14 15:10:19    -123.3456    48.49292 0.0062500000
## 57       DSCN8040.JPG 2022:04:14 15:10:21    -123.3456    48.49291 0.0062500000
## 58       DSCN8041.JPG 2022:04:14 15:10:25    -123.3456    48.49291 0.0012500000
## 59       DSCN8042.JPG 2022:04:14 15:10:26    -123.3456    48.49292 0.0012500000
## 60       DSCN8044.JPG 2022:04:14 15:10:35    -123.3456    48.49292 0.0012500000
## 61       DSCN8045.JPG 2022:04:14 15:10:37    -123.3456    48.49292 0.0008000000
## 62       DSCN8046.JPG 2022:04:14 15:10:39    -123.3456    48.49292 0.0008000000
## 63       DSCN8047.JPG 2022:04:14 15:10:44    -123.3456    48.49291 0.0025000000
## 64       DSCN8048.JPG 2022:04:14 15:14:35    -123.3456    48.49291 0.0031250000
## 65       DSCN8050.JPG 2022:04:14 15:14:40    -123.3458    48.49278 0.0031250000
## 66       DSCN8051.JPG 2022:04:14 15:14:44    -123.3459    48.49280 0.0025000000
## 67       DSCN8052.JPG 2022:04:14 15:40:05    -123.3458    48.49301 0.0166666667
## 68       DSCN8053.JPG 2022:04:14 15:40:15    -123.3461    48.49280 0.0050000000
## 69       DSCN8054.JPG 2022:04:14 15:45:12           NA          NA 0.0020000000
## 70       DSCN8055.JPG 2022:04:14 15:45:15    -123.3458    48.49285 0.0010000000
## 71       DSCN8056.JPG 2022:04:14 15:45:17    -123.3458    48.49289 0.0012500000
## 72       DSCN8057.JPG 2022:04:14 15:45:20    -123.3458    48.49288 0.0008000000
## 73       DSCN8058.JPG 2022:04:14 15:46:11    -123.3462    48.49276 0.0008000000
## 74       DSCN8059.JPG 2022:04:14 15:46:14    -123.3462    48.49275 0.0015625000
## 75       DSCN8060.JPG 2022:04:14 15:47:56    -123.3464    48.49286 0.0040000000
## 76       DSCN8061.JPG 2022:04:14 15:48:07    -123.3464    48.49290 0.0008000000
## 77       DSCN8062.JPG 2022:04:14 15:48:15    -123.3464    48.49290 0.0006666667
## 78       DSCN8063.JPG 2022:04:14 15:48:28    -123.3464    48.49290 0.0025000000
## 79       DSCN8064.JPG 2022:04:14 15:49:12    -123.3465    48.49297 0.0008000000
## 80       DSCN8065.JPG 2022:04:14 15:53:39    -123.3466    48.49294 0.0012500000
## 81       DSCN8066.JPG 2022:04:14 15:53:43    -123.3468    48.49292 0.0015625000
## 82  DSCN8067 copy.JPG 2022:04:14 15:53:46    -123.3468    48.49293 0.0015625000
## 83       DSCN8067.JPG 2022:04:14 15:53:46    -123.3468    48.49293 0.0015625000
## 84       DSCN8068.JPG 2022:04:14 15:53:52    -123.3468    48.49293 0.0012500000
## 85       DSCN8069.JPG 2022:04:14 15:53:55    -123.3468    48.49295 0.0012500000
## 86       DSCN8070.JPG 2022:04:14 15:53:59    -123.3468    48.49296 0.0012500000
## 87       DSCN8071.JPG 2022:04:14 15:55:14    -123.3468    48.49300 0.0015625000
## 88       DSCN8072.JPG 2022:04:14 15:55:17    -123.3468    48.49300 0.0025000000
## 89       DSCN8073.JPG 2022:04:14 15:55:49    -123.3468    48.49300 0.0015625000
## 90  DSCN8074 copy.JPG 2022:04:14 15:56:06    -123.3468    48.49303 0.0031250000
## 91       DSCN8074.JPG 2022:04:14 15:56:06    -123.3468    48.49303 0.0031250000
## 92  DSCN8076 copy.JPG 2022:04:14 15:56:20    -123.3468    48.49302 0.0080000000
## 93       DSCN8076.JPG 2022:04:14 15:56:20    -123.3468    48.49302 0.0080000000
## 94       DSCN8079.JPG 2022:04:14 15:57:04    -123.3468    48.49302 0.0020000000
## 95       DSCN8080.JPG 2022:04:14 15:57:29    -123.3468    48.49302 0.0012500000
## 96       DSCN8082.JPG 2022:04:14 15:57:52    -123.3468    48.49303 0.0020000000
## 97       DSCN8084.JPG 2022:04:14 15:58:14    -123.3468    48.49303 0.0012500000
## 98       DSCN8085.JPG 2022:04:14 15:58:16    -123.3468    48.49303 0.0012500000
## 99       DSCN8088.JPG 2022:04:14 16:02:18    -123.3469    48.49297 0.0050000000
## 100      DSCN8089.JPG 2022:04:14 16:02:22    -123.3469    48.49296 0.0062500000
## 101      DSCN8091.JPG 2022:04:14 16:03:26    -123.3467    48.49304 0.0031250000
## 102      DSCN8092.JPG 2022:04:14 16:03:38    -123.3467    48.49304 0.0031250000
## 103      DSCN8094.JPG 2022:04:14 16:04:20    -123.3468    48.49301 0.0012500000
## 104 DSCN8095 copy.JPG 2022:04:14 16:04:25    -123.3468    48.49301 0.0012500000
## 105      DSCN8095.JPG 2022:04:14 16:04:25    -123.3468    48.49301 0.0012500000
## 106      DSCN8097.JPG 2022:04:14 16:06:02    -123.3465    48.49309 0.0012500000
## 107      DSCN8098.JPG 2022:04:14 16:06:03    -123.3465    48.49309 0.0012500000
## 108      DSCN8099.JPG 2022:04:14 16:06:07    -123.3466    48.49304 0.0012500000
## 109      DSCN8100.JPG 2022:04:14 16:06:12    -123.3466    48.49294 0.0012500000
## 110      DSCN8101.JPG 2022:04:14 16:06:16    -123.3466    48.49292 0.0025000000
## 111      DSCN8102.JPG 2022:04:14 16:11:02    -123.3465    48.49299 0.0012500000
## 112      DSCN8103.JPG 2022:04:14 16:11:14    -123.3463    48.49283 0.0008000000
## 113      DSCN8104.JPG 2022:04:14 16:11:30    -123.3463    48.49282 0.0010000000
## 114      DSCN8105.JPG 2022:04:14 16:11:46    -123.3463    48.49283 0.0012500000
## 115      DSCN8107.JPG 2022:04:14 16:15:18    -123.3463    48.49268 0.0008000000
## 116      DSCN8108.JPG 2022:04:14 16:19:37    -123.3464    48.49247 0.0025000000
## 117      DSCN8109.JPG 2022:04:14 16:19:40    -123.3464    48.49247 0.0025000000
## 118      DSCN8110.JPG 2022:04:14 16:26:36    -123.3449    48.49238 0.0125000000
## 119      DSCN8111.JPG 2022:04:14 16:26:40    -123.3450    48.49238 0.0100000000
## 120      DSCN8112.JPG 2022:04:14 16:26:46    -123.3450    48.49237 0.0010000000
## 121      DSCN8114.JPG 2022:04:14 16:26:49    -123.3450    48.49237 0.0012500000
## 122      DSCN8115.JPG 2022:04:14 16:32:13    -123.3448    48.49186 0.0010000000
## 123      DSCN8117.JPG 2022:04:14 16:32:40    -123.3448    48.49190 0.0025000000
## 124      DSCN8118.JPG 2022:04:14 16:34:46    -123.3449    48.49186 0.0020000000
## 125      DSCN8119.JPG 2022:04:14 16:34:50    -123.3450    48.49175 0.0010000000
## 126      DSCN8120.JPG 2022:04:14 16:34:56    -123.3450    48.49175 0.0015625000
## 127      DSCN8121.JPG 2022:04:14 16:35:05    -123.3449    48.49176 0.0015625000
## 128      DSCN8122.JPG 2022:04:14 16:35:10    -123.3449    48.49175 0.0010000000
## 129      DSCN8123.JPG 2022:04:14 16:35:12    -123.3449    48.49175 0.0010000000
## 130      DSCN8124.JPG 2022:04:14 16:35:13    -123.3449    48.49175 0.0010000000
## 131      DSCN8128.JPG 2022:04:14 16:38:11    -123.3450    48.49201 0.0025000000
## 132      DSCN8131.JPG 2022:04:14 16:38:21    -123.3450    48.49201 0.0031250000
## 133      DSCN8132.JPG 2022:04:14 16:38:24    -123.3450    48.49201 0.0031250000
## 134      DSCN8133.JPG 2022:04:14 16:38:26    -123.3450    48.49201 0.0031250000
## 135      DSCN8134.JPG 2022:04:14 16:38:28    -123.3450    48.49202 0.0031250000
## 136      DSCN8135.JPG 2022:04:14 16:38:29    -123.3450    48.49202 0.0031250000
## 137      DSCN8136.JPG 2022:04:14 16:38:46    -123.3450    48.49205 0.0031250000
## 138      DSCN8137.JPG 2022:04:14 16:39:08    -123.3450    48.49207 0.0025000000
## 139      DSCN8138.JPG 2022:04:14 16:39:12    -123.3450    48.49206 0.0031250000
## 140      DSCN8141.JPG 2022:04:14 16:39:56    -123.3450    48.49208 0.0010000000
## 141      DSCN8142.JPG 2022:04:14 16:39:57    -123.3450    48.49208 0.0010000000
## 142      DSCN8143.JPG 2022:04:14 16:40:07    -123.3450    48.49208 0.0010000000
## 143      DSCN8146.JPG 2022:04:14 16:40:13    -123.3450    48.49207 0.0010000000
## 144      DSCN8147.JPG 2022:04:14 16:41:03    -123.3449    48.49232 0.0010000000
## 145      DSCN8148.JPG 2022:04:14 16:41:22    -123.3448    48.49233 0.0010000000
## 146      DSCN8149.JPG 2022:04:14 16:50:02    -123.3450    48.49245 0.0400000000
## 147      DSCN8150.JPG 2022:04:14 16:50:29    -123.3428    48.49626 0.0400000000
## 148      DSCN8151.JPG 2022:04:14 16:50:35    -123.3428    48.49621 0.0500000000
## 149      DSCN8152.JPG 2022:04:14 16:50:51    -123.3427    48.49616 0.0333333333
## 150      DSCN8153.JPG 2022:04:14 16:51:42    -123.3425    48.49620 0.0333333333
## 151      DSCN8154.JPG 2022:04:14 16:51:48    -123.3425    48.49619 0.0333333333
## 152      DSCN8156.JPG 2022:04:14 16:52:24    -123.3422    48.49614 0.0062500000
## 153      DSCN8157.JPG 2022:04:14 16:52:47    -123.3423    48.49607 0.0333333333
## 154      DSCN8158.JPG 2022:04:14 16:52:51    -123.3423    48.49608 0.0333333333
## 155      DSCN8161.JPG 2022:04:14 16:53:01    -123.3424    48.49608 0.0333333333
## 156      DSCN8162.JPG 2022:04:14 16:53:06    -123.3424    48.49609 0.0333333333
## 157      DSCN8163.JPG 2022:04:14 16:53:19    -123.3423    48.49606 0.0250000000
## 158      DSCN8164.JPG 2022:04:14 16:53:23    -123.3423    48.49609 0.0200000000
## 159      DSCN8165.JPG 2022:04:14 16:53:28    -123.3423    48.49613 0.0333333333
## 160      DSCN8167.JPG 2022:04:14 16:53:59    -123.3422    48.49608 0.0062500000
## 161      DSCN8168.JPG 2022:04:14 16:54:04    -123.3422    48.49609 0.0008000000
## 162      DSCN8169.JPG 2022:04:14 16:54:07    -123.3422    48.49610 0.0050000000
## 163      DSCN8170.JPG 2022:04:14 16:55:51    -123.3420    48.49616 0.0062500000
## 164      DSCN8171.JPG 2022:04:14 16:56:04    -123.3422    48.49643 0.0166666667
## 165      DSCN8172.JPG 2022:04:14 16:56:10    -123.3422    48.49638 0.0333333333
## 166      DSCN8174.JPG 2022:04:14 16:56:16    -123.3422    48.49635 0.0050000000
## 167      DSCN8175.JPG 2022:04:14 16:56:32    -123.3421    48.49627 0.0100000000
## 168      DSCN8176.JPG 2022:04:14 16:57:06    -123.3425    48.49628 0.0080000000
## 169      DSCN8177.JPG 2022:04:14 16:57:09    -123.3425    48.49629 0.0125000000
## 170      DSCN8180.JPG 2022:04:14 16:58:00    -123.3425    48.49620 0.0166666667
## 171      DSCN8182.JPG 2022:04:14 16:58:07    -123.3425    48.49621 0.0100000000
## 172      DSCN8183.JPG 2022:04:14 16:58:13    -123.3425    48.49618 0.0250000000
## 173      DSCN8184.JPG 2022:04:14 17:01:16           NA          NA 0.0333333333
## 174      DSCN8185.JPG 2022:04:14 17:01:40    -123.3423    48.49628 0.0080000000
## 175      DSCN8188.JPG 2022:04:14 17:02:02    -123.3424    48.49634 0.0100000000
## 176      DSCN8189.JPG 2022:04:14 17:02:14    -123.3423    48.49626 0.0333333333
## 177      DSCN8191.JPG 2022:04:14 17:02:19    -123.3423    48.49624 0.0333333333
## 178      DSCN8192.JPG 2022:04:14 17:02:38    -123.3423    48.49624 0.0250000000
## 179      DSCN8196.JPG 2022:04:14 17:02:51    -123.3423    48.49630 0.0333333333
## 180      DSCN8198.JPG 2022:04:14 17:03:05    -123.3423    48.49621 0.0333333333
## 181      DSCN8199.JPG 2022:04:14 17:04:38    -123.3428    48.49634 0.0333333333
## 182      DSCN8200.JPG 2022:04:14 17:05:06    -123.3428    48.49627 0.0040000000
## 183      DSCN8201.JPG 2022:04:14 17:05:10    -123.3428    48.49627 0.0333333333
## 184      DSCN8202.JPG 2022:04:14 17:05:12    -123.3428    48.49627 0.0166666667
## 185      DSCN8203.JPG 2022:04:14 17:05:14    -123.3428    48.49628 0.0125000000
## 186      DSCN8204.JPG 2022:04:14 17:05:16    -123.3428    48.49628 0.0040000000
## 187      DSCN8205.JPG 2022:04:14 17:16:22    -123.3428    48.49645 0.0333333333
## 188      DSCN8206.JPG 2022:04:14 17:16:27    -123.3428    48.49642 0.0333333333
## 189      DSCN8207.JPG 2022:04:14 17:16:30    -123.3427    48.49637 0.0025000000
## 190      DSCN8208.JPG 2022:04:14 17:16:35    -123.3427    48.49638 0.0333333333
## 191      DSCN8209.JPG 2022:04:14 17:26:20           NA          NA 0.0200000000
## 192      DSCN8211.JPG 2022:04:14 17:26:30    -123.3382    48.49101 0.0200000000
## 193      DSCN8212.JPG 2022:04:14 17:26:35    -123.3382    48.49101 0.0200000000
## 194      DSCN8213.JPG 2022:04:14 17:26:36    -123.3382    48.49101 0.0200000000
## 195      DSCN8215.JPG 2022:04:14 17:26:48    -123.3383    48.49098 0.0333333333
## 196      DSCN8216.JPG 2022:04:14 17:26:50    -123.3383    48.49096 0.0333333333
## 197      DSCN8217.JPG 2022:04:14 17:26:56    -123.3383    48.49094 0.0333333333
## 198      DSCN8218.JPG 2022:04:14 17:27:15    -123.3382    48.49085 0.0333333333
## 199      DSCN8219.JPG 2022:04:14 17:27:29    -123.3382    48.49092 0.0200000000
## 200      DSCN8220.JPG 2022:04:14 17:27:37    -123.3382    48.49094 0.0166666667
## 201      DSCN8221.JPG 2022:04:14 17:28:25    -123.3380    48.49093 0.0400000000
## 202      DSCN8222.JPG 2022:04:14 17:28:32    -123.3380    48.49092 0.0333333333
## 203      DSCN8223.JPG 2022:04:14 17:28:40    -123.3380    48.49095 0.0100000000
## 204      DSCN8225.JPG 2022:04:14 17:28:49    -123.3380    48.49095 0.0200000000
## 205      DSCN8227.JPG 2022:04:14 17:29:10    -123.3381    48.49095 0.0333333333
## 206      DSCN8229.JPG 2022:04:14 17:29:29    -123.3382    48.49106 0.0200000000
## 207      DSCN8230.JPG 2022:04:14 17:29:48    -123.3383    48.49115 0.0100000000
## 208      DSCN8231.JPG 2022:04:14 17:29:52    -123.3384    48.49121 0.0166666667
## 209      DSCN8232.JPG 2022:04:14 17:30:10    -123.3384    48.49123 0.0333333333
## 210      DSCN8234.JPG 2022:04:14 17:30:38    -123.3385    48.49136 0.0333333333
## 211      DSCN8236.JPG 2022:04:14 17:31:00    -123.3387    48.49143 0.0333333333
## 212      DSCN8237.JPG 2022:04:14 17:31:05    -123.3387    48.49142 0.0050000000
## 213      DSCN8238.JPG 2022:04:14 17:31:27    -123.3387    48.49137 0.0333333333
## 214      DSCN8239.JPG 2022:04:14 17:32:05    -123.3389    48.49135 0.0080000000
## 215      DSCN8242.JPG 2022:04:14 17:32:27    -123.3390    48.49139 0.0333333333
## 216      DSCN8244.JPG 2022:04:14 17:32:35    -123.3389    48.49141 0.0333333333
## 217      DSCN8245.JPG 2022:04:14 17:32:42    -123.3389    48.49143 0.0500000000
## 218      DSCN8246.JPG 2022:04:14 17:32:43    -123.3389    48.49142 0.0500000000
## 219      DSCN8247.JPG 2022:04:14 17:32:48    -123.3389    48.49138 0.0333333333
## 220      DSCN8248.JPG 2022:04:14 17:33:03    -123.3390    48.49137 0.0333333333
## 221      DSCN8251.JPG 2022:04:14 17:33:10    -123.3390    48.49135 0.0333333333
## 222      DSCN8255.JPG 2022:04:14 17:33:17    -123.3390    48.49129 0.0333333333
## 223      DSCN8258.JPG 2022:04:14 17:33:29    -123.3390    48.49126 0.0333333333
## 224      DSCN8259.JPG 2022:04:14 17:33:31    -123.3390    48.49128 0.0333333333
## 225      DSCN8275.JPG 2022:04:14 17:34:19    -123.3390    48.49138 0.0333333333
## 226      DSCN8276.JPG 2022:04:14 17:34:25    -123.3390    48.49140 0.0250000000
## 227      DSCN8277.JPG 2022:04:14 17:34:26    -123.3390    48.49140 0.0250000000
## 228      DSCN8280.JPG 2022:04:14 17:34:49    -123.3390    48.49141 0.0200000000
## 229      DSCN8281.JPG 2022:04:14 17:34:55    -123.3390    48.49142 0.0166666667
## 230      DSCN8283.JPG 2022:04:14 17:35:15    -123.3390    48.49144 0.0333333333
## 231      DSCN8285.JPG 2022:04:14 17:36:10    -123.3394    48.49144 0.0400000000
## 232      DSCN8287.JPG 2022:04:14 17:36:29    -123.3394    48.49140 0.0333333333
## 233      DSCN8288.JPG 2022:04:14 17:36:36    -123.3394    48.49139 0.0333333333
## 234      DSCN8289.JPG 2022:04:14 17:36:45    -123.3393    48.49134 0.0400000000
## 235      DSCN8290.JPG 2022:04:14 17:36:51    -123.3393    48.49133 0.0400000000
## 236      DSCN8292.JPG 2022:04:14 17:37:00    -123.3392    48.49132 0.0400000000
## 237      DSCN8293.JPG 2022:04:14 17:37:30    -123.3395    48.49129 0.0666666667
## 238      DSCN8294.JPG 2022:04:14 17:37:31    -123.3395    48.49129 0.0666666667
## 239      DSCN8295.JPG 2022:04:14 17:38:40    -123.3398    48.49117 0.0333333333
## 240      DSCN8296.JPG 2022:04:14 17:38:45    -123.3398    48.49115 0.0333333333
## 241      DSCN8298.JPG 2022:04:14 17:39:09    -123.3398    48.49118 0.0333333333
## 242      DSCN8299.JPG 2022:04:14 17:39:11    -123.3398    48.49117 0.0333333333
## 243      DSCN8304.JPG 2022:04:14 17:39:47    -123.3399    48.49123 0.0333333333
## 244      DSCN8306.JPG 2022:04:14 17:39:56    -123.3399    48.49127 0.0333333333
## 245      DSCN8308.JPG 2022:04:14 17:40:31    -123.3401    48.49125 0.0666666667
## 246      DSCN8309.JPG 2022:04:14 17:40:48    -123.3401    48.49119 0.0333333333
## 247      DSCN8310.JPG 2022:04:14 17:41:33    -123.3400    48.49099 0.0400000000
## 248      DSCN8312.JPG 2022:04:14 17:43:49    -123.3399    48.49101 0.0050000000
## 249      DSCN8314.JPG 2022:04:14 17:44:09    -123.3404    48.49117 0.0050000000
## 250      DSCN8315.JPG 2022:04:14 17:44:26    -123.3405    48.49117 0.1000000000
## 251      DSCN8316.JPG 2022:04:14 17:44:39    -123.3404    48.49106 0.0400000000
## 252      DSCN8317.JPG 2022:04:14 17:44:41    -123.3404    48.49107 0.0400000000
## 253      DSCN8320.JPG 2022:04:14 17:50:37    -123.3398    48.49123 0.0333333333
## 254      DSCN8324.JPG 2022:04:14 17:51:16    -123.3397    48.49128 0.0333333333
## 255      DSCN8328.JPG 2022:04:14 17:51:26    -123.3397    48.49126 0.0333333333
## 256      DSCN8330.JPG 2022:04:14 17:53:36    -123.3391    48.49155 0.0666666667
## 257      DSCN8333.JPG 2022:04:14 17:57:30    -123.3388    48.49129 0.0666666667
## 258      DSCN8334.JPG 2022:04:14 17:57:58    -123.3390    48.49148 0.0333333333
##     FNumber ISO FocalLength
## 1       8.8 125        10.1
## 2       9.1 125        13.0
## 3       9.1 125        13.0
## 4       4.9 125        21.5
## 5       4.9 125        21.5
## 6       4.9 125        21.5
## 7       4.9 125        21.5
## 8       4.9 125        21.5
## 9       4.9 125        21.5
## 10      4.9 125        21.5
## 11      4.2 125         7.2
## 12      4.2 125         7.2
## 13      4.2 125         7.2
## 14      4.2 125         7.2
## 15      4.2 125         7.2
## 16      4.2 125         7.2
## 17      4.2 125         7.2
## 18      4.2 125         7.2
## 19      4.2 125         7.2
## 20      4.2 125         7.2
## 21      4.2 125         7.2
## 22      4.2 125         7.2
## 23      4.2 125         7.2
## 24      4.2 125         7.2
## 25      4.2 125         7.2
## 26      4.2 125         7.2
## 27      2.8 125         5.1
## 28      2.8 125         5.1
## 29      2.8 125         5.1
## 30      2.8 125         4.3
## 31      2.8 125         4.3
## 32      2.8 125         4.3
## 33      2.8 125         4.3
## 34      2.8 125         4.3
## 35      2.8 125         4.3
## 36      2.8 125         4.3
## 37      2.8 125         4.3
## 38      2.8 125         4.3
## 39      2.8 125         4.3
## 40      2.8 125         4.3
## 41      4.1 125         4.3
## 42      4.1 125         4.3
## 43      2.8 125         4.3
## 44      4.1 125         4.3
## 45      4.2 125         6.1
## 46      4.2 125         6.1
## 47      4.2 125         6.1
## 48      4.2 125         6.1
## 49      4.4 125        10.1
## 50      4.4 125        10.1
## 51      4.4 125        10.1
## 52      4.4 125        10.1
## 53      4.4 125        10.1
## 54      4.4 125        10.1
## 55      4.4 125        10.1
## 56      4.4 125        10.1
## 57      4.4 125        10.1
## 58      4.4 125        10.1
## 59      4.4 125        10.1
## 60      4.4 125        10.1
## 61      4.4 125        10.1
## 62      4.4 125        10.1
## 63      4.4 125        10.1
## 64      4.4 125        10.1
## 65      4.4 125        10.1
## 66      4.4 125        10.1
## 67      4.4 125        10.1
## 68      2.8 125         4.3
## 69      2.8 125         4.3
## 70      4.1 125         4.3
## 71      4.1 125         4.3
## 72      2.8 125         4.3
## 73      4.1 125         4.3
## 74      8.2 125         4.3
## 75      2.8 125         4.3
## 76      2.8 125         4.3
## 77      4.1 125         4.3
## 78      8.2 125         4.3
## 79      2.8 125         4.3
## 80      4.4 125        10.1
## 81      4.4 125        10.1
## 82      4.4 125        10.1
## 83      4.4 125        10.1
## 84      4.4 125        10.1
## 85      4.4 125        10.1
## 86      4.4 125        10.1
## 87      4.4 125        10.1
## 88      4.4 125        10.1
## 89      4.4 125        10.1
## 90      4.4 125        10.1
## 91      4.4 125        10.1
## 92      4.4 125        10.1
## 93      4.4 125        10.1
## 94      4.4 125        10.1
## 95      4.4 125        10.1
## 96      4.4 125        10.1
## 97      4.4 125        10.1
## 98      4.4 125        10.1
## 99      4.4 125        11.0
## 100     4.9 125        21.5
## 101     4.9 125        21.5
## 102     4.9 125        21.5
## 103     4.9 125        21.5
## 104     4.9 125        21.5
## 105     4.9 125        21.5
## 106     4.2 125         6.1
## 107     4.2 125         6.1
## 108     4.2 125         6.1
## 109     4.2 125         6.1
## 110     4.2 125         6.1
## 111     4.4 125        10.1
## 112     4.1 125         4.3
## 113     4.2 125         6.6
## 114     4.2 125         6.6
## 115     4.2 125         6.6
## 116     4.2 125         6.6
## 117     4.2 125         6.6
## 118     4.4 125        10.1
## 119     4.4 125        10.1
## 120     4.4 125        10.1
## 121     4.4 125        10.1
## 122     4.4 125        10.1
## 123     4.9 125        21.5
## 124     2.8 125         5.1
## 125     2.8 125         5.1
## 126     2.8 125         5.1
## 127     8.3 125         5.1
## 128     8.8 125        10.1
## 129     8.8 125        10.1
## 130     8.8 125        10.1
## 131     4.9 125        21.5
## 132     4.9 125        21.5
## 133     4.9 125        21.5
## 134     4.9 125        21.5
## 135     4.9 125        21.5
## 136     4.9 125        21.5
## 137     4.2 125         6.6
## 138     4.2 125         6.6
## 139     4.7 125        16.6
## 140     4.1 125         4.7
## 141     4.1 125         4.7
## 142     4.1 125         4.7
## 143     4.1 125         4.7
## 144     2.8 125         4.7
## 145     4.1 125         4.7
## 146     4.4 400        10.1
## 147     4.2 400         6.6
## 148     4.2 400         6.6
## 149     4.2 280         6.6
## 150     4.2 360         6.6
## 151     4.2 360         6.6
## 152     4.2 125         6.6
## 153     4.2 220         6.6
## 154     4.2 220         6.6
## 155     4.2 160         6.6
## 156     4.2 160         6.6
## 157     4.2 125         6.6
## 158     4.2 125         6.6
## 159     4.2 125         6.6
## 160     2.8 125         4.3
## 161     2.8 125         4.3
## 162     2.8 125         4.3
## 163     2.8 125         4.3
## 164     2.8 125         4.3
## 165     2.8 125         4.3
## 166     2.8 125         4.3
## 167     2.8 125         4.3
## 168     2.8 125         4.3
## 169     2.8 125         4.3
## 170     4.2 125         6.6
## 171     4.2 125         6.6
## 172     4.2 125         6.6
## 173     4.2 125         6.6
## 174     4.2 125         6.6
## 175     4.2 125         6.6
## 176     4.2 125         6.6
## 177     4.2 125         6.6
## 178     4.2 125         6.6
## 179     4.2 125         6.6
## 180     4.2 125         6.6
## 181     4.2 280         6.6
## 182     4.2 125         6.6
## 183     4.2 280         6.6
## 184     4.2 125         6.6
## 185     4.2 125         6.6
## 186     4.2 125         6.6
## 187     2.8 250         4.3
## 188     2.8 180         4.3
## 189     2.8 125         4.3
## 190     2.8 160         4.3
## 191     4.4 125        10.1
## 192     4.4 125        10.1
## 193     4.4 125        10.1
## 194     4.4 125        10.1
## 195     4.4 220        10.1
## 196     4.4 250        10.1
## 197     4.4 320        10.1
## 198     4.4 250        10.1
## 199     4.2 125         6.1
## 200     4.2 125         6.1
## 201     4.2 400         6.1
## 202     2.8 180         4.3
## 203     2.8 125         4.3
## 204     2.8 125         4.3
## 205     4.2 140         6.1
## 206     4.2 125         6.1
## 207     4.2 125         6.1
## 208     4.2 125         6.1
## 209     4.2 400         6.1
## 210     4.2 250         6.1
## 211     4.2 280         6.1
## 212     4.2 125         6.1
## 213     4.2 280         6.1
## 214     4.2 125         6.1
## 215     4.2 320         6.1
## 216     4.2 400         6.1
## 217     4.2 400         6.1
## 218     4.2 400         6.1
## 219     4.2 280         6.1
## 220     4.2 400         6.1
## 221     4.2 400         6.1
## 222     4.2 400         6.1
## 223     4.2 360         6.1
## 224     4.2 360         6.1
## 225     4.2 200         6.1
## 226     4.2 125         6.1
## 227     4.2 125         6.1
## 228     4.2 125         6.1
## 229     4.2 125         6.1
## 230     4.2 200         6.1
## 231     4.2 400         6.1
## 232     4.2 400         6.1
## 233     4.2 400         6.1
## 234     4.2 400         6.1
## 235     4.2 400         6.1
## 236     4.2 400         6.1
## 237     4.2 400         6.1
## 238     4.2 400         6.1
## 239     4.2 400         6.1
## 240     4.2 400         6.1
## 241     4.2 280         6.1
## 242     4.2 160         6.1
## 243     4.2 320         6.1
## 244     4.2 360         6.1
## 245     4.2 400         6.1
## 246     4.2 360         6.1
## 247     4.2 400         6.1
## 248     4.2 125         6.1
## 249     4.2 125         6.1
## 250     4.2 450         6.1
## 251     2.8 400         4.3
## 252     2.8 400         4.3
## 253     4.4 220        10.1
## 254     4.4 400        10.1
## 255     4.4 220        10.1
## 256     4.4 400        10.1
## 257     4.8 900        18.1
## 258     2.8 200         5.1

3.1.1 Rename columns

colnames(exif)
## [1] "SourceFile"       "DateTimeOriginal" "GPSLongitude"     "GPSLatitude"     
## [5] "ExposureTime"     "FNumber"          "ISO"              "FocalLength"
names(exif)[1] <- "Image"
names(exif)[2] <- "Date"
names(exif)[3] <- "Longitude"
names(exif)[4] <- "Latitude"
names(exif)[5] <- "Exposure"
names(exif)[6] <- "F-Stop"
names(exif)[7] <- "ISO"
names(exif)[8] <- "Focal"

colnames(exif)
## [1] "Image"     "Date"      "Longitude" "Latitude"  "Exposure"  "F-Stop"   
## [7] "ISO"       "Focal"

3.1.2 Add column

exif$Desc <- ""
exif$Name <- ""
exif$Location <- "Mt. Douglas"
str(exif)
## 'data.frame':    258 obs. of  11 variables:
##  $ Image    : chr  "DSCN7961.JPG" "DSCN7962.JPG" "DSCN7963.JPG" "DSCN7965.JPG" ...
##  $ Date     : chr  "2022:04:14 14:21:41" "2022:04:14 14:21:47" "2022:04:14 14:21:54" "2022:04:14 14:50:57" ...
##  $ Longitude: num  NA NA NA -123 -123 ...
##  $ Latitude : num  NA NA NA 48.5 48.5 ...
##  $ Exposure : num  0.002 0.002 0.002 0.0025 0.0025 0.0025 0.0025 0.0025 0.0025 0.0025 ...
##  $ F-Stop   : num  8.8 9.1 9.1 4.9 4.9 4.9 4.9 4.9 4.9 4.9 ...
##  $ ISO      : int  125 125 125 125 125 125 125 125 125 125 ...
##  $ Focal    : num  10.1 13 13 21.5 21.5 21.5 21.5 21.5 21.5 21.5 ...
##  $ Desc     : chr  "" "" "" "" ...
##  $ Name     : chr  "" "" "" "" ...
##  $ Location : chr  "Mt. Douglas" "Mt. Douglas" "Mt. Douglas" "Mt. Douglas" ...

3.2 Convert Date to time format

exif$Date <- lubridate::ymd_hms(exif$Date, tz=Sys.timezone())
str(exif)
## 'data.frame':    258 obs. of  11 variables:
##  $ Image    : chr  "DSCN7961.JPG" "DSCN7962.JPG" "DSCN7963.JPG" "DSCN7965.JPG" ...
##  $ Date     : POSIXct, format: "2022-04-14 14:21:41" "2022-04-14 14:21:47" ...
##  $ Longitude: num  NA NA NA -123 -123 ...
##  $ Latitude : num  NA NA NA 48.5 48.5 ...
##  $ Exposure : num  0.002 0.002 0.002 0.0025 0.0025 0.0025 0.0025 0.0025 0.0025 0.0025 ...
##  $ F-Stop   : num  8.8 9.1 9.1 4.9 4.9 4.9 4.9 4.9 4.9 4.9 ...
##  $ ISO      : int  125 125 125 125 125 125 125 125 125 125 ...
##  $ Focal    : num  10.1 13 13 21.5 21.5 21.5 21.5 21.5 21.5 21.5 ...
##  $ Desc     : chr  "" "" "" "" ...
##  $ Name     : chr  "" "" "" "" ...
##  $ Location : chr  "Mt. Douglas" "Mt. Douglas" "Mt. Douglas" "Mt. Douglas" ...

3.3 add data to Name & Desc columns

head(exif)
##          Image                Date Longitude Latitude Exposure F-Stop ISO Focal
## 1 DSCN7961.JPG 2022-04-14 14:21:41        NA       NA   0.0020    8.8 125  10.1
## 2 DSCN7962.JPG 2022-04-14 14:21:47        NA       NA   0.0020    9.1 125  13.0
## 3 DSCN7963.JPG 2022-04-14 14:21:54        NA       NA   0.0020    9.1 125  13.0
## 4 DSCN7965.JPG 2022-04-14 14:50:57 -123.3453 48.49260   0.0025    4.9 125  21.5
## 5 DSCN7966.JPG 2022-04-14 14:51:05 -123.3452 48.49255   0.0025    4.9 125  21.5
## 6 DSCN7967.JPG 2022-04-14 14:51:11 -123.3452 48.49252   0.0025    4.9 125  21.5
##   Desc Name    Location
## 1           Mt. Douglas
## 2           Mt. Douglas
## 3           Mt. Douglas
## 4           Mt. Douglas
## 5           Mt. Douglas
## 6           Mt. Douglas
exif_rows <- row.names(exif)
print(exif_rows)
##   [1] "1"   "2"   "3"   "4"   "5"   "6"   "7"   "8"   "9"   "10"  "11"  "12" 
##  [13] "13"  "14"  "15"  "16"  "17"  "18"  "19"  "20"  "21"  "22"  "23"  "24" 
##  [25] "25"  "26"  "27"  "28"  "29"  "30"  "31"  "32"  "33"  "34"  "35"  "36" 
##  [37] "37"  "38"  "39"  "40"  "41"  "42"  "43"  "44"  "45"  "46"  "47"  "48" 
##  [49] "49"  "50"  "51"  "52"  "53"  "54"  "55"  "56"  "57"  "58"  "59"  "60" 
##  [61] "61"  "62"  "63"  "64"  "65"  "66"  "67"  "68"  "69"  "70"  "71"  "72" 
##  [73] "73"  "74"  "75"  "76"  "77"  "78"  "79"  "80"  "81"  "82"  "83"  "84" 
##  [85] "85"  "86"  "87"  "88"  "89"  "90"  "91"  "92"  "93"  "94"  "95"  "96" 
##  [97] "97"  "98"  "99"  "100" "101" "102" "103" "104" "105" "106" "107" "108"
## [109] "109" "110" "111" "112" "113" "114" "115" "116" "117" "118" "119" "120"
## [121] "121" "122" "123" "124" "125" "126" "127" "128" "129" "130" "131" "132"
## [133] "133" "134" "135" "136" "137" "138" "139" "140" "141" "142" "143" "144"
## [145] "145" "146" "147" "148" "149" "150" "151" "152" "153" "154" "155" "156"
## [157] "157" "158" "159" "160" "161" "162" "163" "164" "165" "166" "167" "168"
## [169] "169" "170" "171" "172" "173" "174" "175" "176" "177" "178" "179" "180"
## [181] "181" "182" "183" "184" "185" "186" "187" "188" "189" "190" "191" "192"
## [193] "193" "194" "195" "196" "197" "198" "199" "200" "201" "202" "203" "204"
## [205] "205" "206" "207" "208" "209" "210" "211" "212" "213" "214" "215" "216"
## [217] "217" "218" "219" "220" "221" "222" "223" "224" "225" "226" "227" "228"
## [229] "229" "230" "231" "232" "233" "234" "235" "236" "237" "238" "239" "240"
## [241] "241" "242" "243" "244" "245" "246" "247" "248" "249" "250" "251" "252"
## [253] "253" "254" "255" "256" "257" "258"
str(exif_rows)
##  chr [1:258] "1" "2" "3" "4" "5" "6" "7" "8" "9" "10" "11" "12" "13" "14" ...
exif$Image
##   [1] "DSCN7961.JPG"      "DSCN7962.JPG"      "DSCN7963.JPG"     
##   [4] "DSCN7965.JPG"      "DSCN7966.JPG"      "DSCN7967.JPG"     
##   [7] "DSCN7968.JPG"      "DSCN7969.JPG"      "DSCN7970 copy.JPG"
##  [10] "DSCN7970.JPG"      "DSCN7971.JPG"      "DSCN7973.JPG"     
##  [13] "DSCN7975.JPG"      "DSCN7977.JPG"      "DSCN7978.JPG"     
##  [16] "DSCN7979.JPG"      "DSCN7980.JPG"      "DSCN7982.JPG"     
##  [19] "DSCN7983.JPG"      "DSCN7984.JPG"      "DSCN7985.JPG"     
##  [22] "DSCN7987.JPG"      "DSCN7988.JPG"      "DSCN7989.JPG"     
##  [25] "DSCN7991.JPG"      "DSCN7992.JPG"      "DSCN7999.JPG"     
##  [28] "DSCN8000.JPG"      "DSCN8002.JPG"      "DSCN8004.JPG"     
##  [31] "DSCN8005.JPG"      "DSCN8006.JPG"      "DSCN8007.JPG"     
##  [34] "DSCN8008.JPG"      "DSCN8009.JPG"      "DSCN8011.JPG"     
##  [37] "DSCN8012.JPG"      "DSCN8013.JPG"      "DSCN8014.JPG"     
##  [40] "DSCN8017.JPG"      "DSCN8018.JPG"      "DSCN8019.JPG"     
##  [43] "DSCN8020.JPG"      "DSCN8021.JPG"      "DSCN8023.JPG"     
##  [46] "DSCN8024.JPG"      "DSCN8025.JPG"      "DSCN8026.JPG"     
##  [49] "DSCN8027.JPG"      "DSCN8030.JPG"      "DSCN8031.JPG"     
##  [52] "DSCN8032.JPG"      "DSCN8034.JPG"      "DSCN8036.JPG"     
##  [55] "DSCN8038.JPG"      "DSCN8039.JPG"      "DSCN8040.JPG"     
##  [58] "DSCN8041.JPG"      "DSCN8042.JPG"      "DSCN8044.JPG"     
##  [61] "DSCN8045.JPG"      "DSCN8046.JPG"      "DSCN8047.JPG"     
##  [64] "DSCN8048.JPG"      "DSCN8050.JPG"      "DSCN8051.JPG"     
##  [67] "DSCN8052.JPG"      "DSCN8053.JPG"      "DSCN8054.JPG"     
##  [70] "DSCN8055.JPG"      "DSCN8056.JPG"      "DSCN8057.JPG"     
##  [73] "DSCN8058.JPG"      "DSCN8059.JPG"      "DSCN8060.JPG"     
##  [76] "DSCN8061.JPG"      "DSCN8062.JPG"      "DSCN8063.JPG"     
##  [79] "DSCN8064.JPG"      "DSCN8065.JPG"      "DSCN8066.JPG"     
##  [82] "DSCN8067 copy.JPG" "DSCN8067.JPG"      "DSCN8068.JPG"     
##  [85] "DSCN8069.JPG"      "DSCN8070.JPG"      "DSCN8071.JPG"     
##  [88] "DSCN8072.JPG"      "DSCN8073.JPG"      "DSCN8074 copy.JPG"
##  [91] "DSCN8074.JPG"      "DSCN8076 copy.JPG" "DSCN8076.JPG"     
##  [94] "DSCN8079.JPG"      "DSCN8080.JPG"      "DSCN8082.JPG"     
##  [97] "DSCN8084.JPG"      "DSCN8085.JPG"      "DSCN8088.JPG"     
## [100] "DSCN8089.JPG"      "DSCN8091.JPG"      "DSCN8092.JPG"     
## [103] "DSCN8094.JPG"      "DSCN8095 copy.JPG" "DSCN8095.JPG"     
## [106] "DSCN8097.JPG"      "DSCN8098.JPG"      "DSCN8099.JPG"     
## [109] "DSCN8100.JPG"      "DSCN8101.JPG"      "DSCN8102.JPG"     
## [112] "DSCN8103.JPG"      "DSCN8104.JPG"      "DSCN8105.JPG"     
## [115] "DSCN8107.JPG"      "DSCN8108.JPG"      "DSCN8109.JPG"     
## [118] "DSCN8110.JPG"      "DSCN8111.JPG"      "DSCN8112.JPG"     
## [121] "DSCN8114.JPG"      "DSCN8115.JPG"      "DSCN8117.JPG"     
## [124] "DSCN8118.JPG"      "DSCN8119.JPG"      "DSCN8120.JPG"     
## [127] "DSCN8121.JPG"      "DSCN8122.JPG"      "DSCN8123.JPG"     
## [130] "DSCN8124.JPG"      "DSCN8128.JPG"      "DSCN8131.JPG"     
## [133] "DSCN8132.JPG"      "DSCN8133.JPG"      "DSCN8134.JPG"     
## [136] "DSCN8135.JPG"      "DSCN8136.JPG"      "DSCN8137.JPG"     
## [139] "DSCN8138.JPG"      "DSCN8141.JPG"      "DSCN8142.JPG"     
## [142] "DSCN8143.JPG"      "DSCN8146.JPG"      "DSCN8147.JPG"     
## [145] "DSCN8148.JPG"      "DSCN8149.JPG"      "DSCN8150.JPG"     
## [148] "DSCN8151.JPG"      "DSCN8152.JPG"      "DSCN8153.JPG"     
## [151] "DSCN8154.JPG"      "DSCN8156.JPG"      "DSCN8157.JPG"     
## [154] "DSCN8158.JPG"      "DSCN8161.JPG"      "DSCN8162.JPG"     
## [157] "DSCN8163.JPG"      "DSCN8164.JPG"      "DSCN8165.JPG"     
## [160] "DSCN8167.JPG"      "DSCN8168.JPG"      "DSCN8169.JPG"     
## [163] "DSCN8170.JPG"      "DSCN8171.JPG"      "DSCN8172.JPG"     
## [166] "DSCN8174.JPG"      "DSCN8175.JPG"      "DSCN8176.JPG"     
## [169] "DSCN8177.JPG"      "DSCN8180.JPG"      "DSCN8182.JPG"     
## [172] "DSCN8183.JPG"      "DSCN8184.JPG"      "DSCN8185.JPG"     
## [175] "DSCN8188.JPG"      "DSCN8189.JPG"      "DSCN8191.JPG"     
## [178] "DSCN8192.JPG"      "DSCN8196.JPG"      "DSCN8198.JPG"     
## [181] "DSCN8199.JPG"      "DSCN8200.JPG"      "DSCN8201.JPG"     
## [184] "DSCN8202.JPG"      "DSCN8203.JPG"      "DSCN8204.JPG"     
## [187] "DSCN8205.JPG"      "DSCN8206.JPG"      "DSCN8207.JPG"     
## [190] "DSCN8208.JPG"      "DSCN8209.JPG"      "DSCN8211.JPG"     
## [193] "DSCN8212.JPG"      "DSCN8213.JPG"      "DSCN8215.JPG"     
## [196] "DSCN8216.JPG"      "DSCN8217.JPG"      "DSCN8218.JPG"     
## [199] "DSCN8219.JPG"      "DSCN8220.JPG"      "DSCN8221.JPG"     
## [202] "DSCN8222.JPG"      "DSCN8223.JPG"      "DSCN8225.JPG"     
## [205] "DSCN8227.JPG"      "DSCN8229.JPG"      "DSCN8230.JPG"     
## [208] "DSCN8231.JPG"      "DSCN8232.JPG"      "DSCN8234.JPG"     
## [211] "DSCN8236.JPG"      "DSCN8237.JPG"      "DSCN8238.JPG"     
## [214] "DSCN8239.JPG"      "DSCN8242.JPG"      "DSCN8244.JPG"     
## [217] "DSCN8245.JPG"      "DSCN8246.JPG"      "DSCN8247.JPG"     
## [220] "DSCN8248.JPG"      "DSCN8251.JPG"      "DSCN8255.JPG"     
## [223] "DSCN8258.JPG"      "DSCN8259.JPG"      "DSCN8275.JPG"     
## [226] "DSCN8276.JPG"      "DSCN8277.JPG"      "DSCN8280.JPG"     
## [229] "DSCN8281.JPG"      "DSCN8283.JPG"      "DSCN8285.JPG"     
## [232] "DSCN8287.JPG"      "DSCN8288.JPG"      "DSCN8289.JPG"     
## [235] "DSCN8290.JPG"      "DSCN8292.JPG"      "DSCN8293.JPG"     
## [238] "DSCN8294.JPG"      "DSCN8295.JPG"      "DSCN8296.JPG"     
## [241] "DSCN8298.JPG"      "DSCN8299.JPG"      "DSCN8304.JPG"     
## [244] "DSCN8306.JPG"      "DSCN8308.JPG"      "DSCN8309.JPG"     
## [247] "DSCN8310.JPG"      "DSCN8312.JPG"      "DSCN8314.JPG"     
## [250] "DSCN8315.JPG"      "DSCN8316.JPG"      "DSCN8317.JPG"     
## [253] "DSCN8320.JPG"      "DSCN8324.JPG"      "DSCN8328.JPG"     
## [256] "DSCN8330.JPG"      "DSCN8333.JPG"      "DSCN8334.JPG"
# try to name 2 rows at once >> using c()
exif[c("4", "5", "6", "7", "8", "9", "10"), "Name"] <- "Bee Fly" # 4-10
exif[c("11", "14", "17"), "Name"] <- "Fawn Lily" # 11, 14, 17
exif["13", "Name"] <- "Miners Lettuce" # 13
exif[c("15", "16"), "Name"] <- "Licorice Fern" # 15, 16
exif[c("18", "19", "20", "21", "39", "40"), "Name"] <- "Monkey Flower" # 18, 19, 20, 21
exif[c("26", "27", "27", "27", "30", "31", "32", "33"), "Name"] <- "Chocolate Lily" # 26, 27, 28, 29, 30, 31, 32, 33

exif[c("4", "5", "6", "7", "8", "9", "10"), "Desc"] <- "BF"  #"Bee Fly" # 4-10
exif[c("11", "14", "17"), "Desc"] <- "FL" # "Fawn Lily" # 11, 14, 17
exif["13", "Desc"] <- "ML" #"Miner's Lettuce" # 13
exif[c("15", "16"), "Desc"] <- "LF" #"Licorice Fern" # 15, 16
exif[c("18", "19", "20", "21"), "Desc"] <- "MF" # "Monkey Flower" # 18, 19, 20, 21
exif[c("26", "27", "27", "27", "30", "31", "32", "33"), "Desc"] <- "CL" #"Chocolate Lily" # 26, 27, 28, 29, 30, 31, 32, 33


exif_rows_list <- exif[, c("Image", "Name", "Desc")]
exif_rows_list
##                 Image           Name Desc
## 1        DSCN7961.JPG                    
## 2        DSCN7962.JPG                    
## 3        DSCN7963.JPG                    
## 4        DSCN7965.JPG        Bee Fly   BF
## 5        DSCN7966.JPG        Bee Fly   BF
## 6        DSCN7967.JPG        Bee Fly   BF
## 7        DSCN7968.JPG        Bee Fly   BF
## 8        DSCN7969.JPG        Bee Fly   BF
## 9   DSCN7970 copy.JPG        Bee Fly   BF
## 10       DSCN7970.JPG        Bee Fly   BF
## 11       DSCN7971.JPG      Fawn Lily   FL
## 12       DSCN7973.JPG                    
## 13       DSCN7975.JPG Miners Lettuce   ML
## 14       DSCN7977.JPG      Fawn Lily   FL
## 15       DSCN7978.JPG  Licorice Fern   LF
## 16       DSCN7979.JPG  Licorice Fern   LF
## 17       DSCN7980.JPG      Fawn Lily   FL
## 18       DSCN7982.JPG  Monkey Flower   MF
## 19       DSCN7983.JPG  Monkey Flower   MF
## 20       DSCN7984.JPG  Monkey Flower   MF
## 21       DSCN7985.JPG  Monkey Flower   MF
## 22       DSCN7987.JPG                    
## 23       DSCN7988.JPG                    
## 24       DSCN7989.JPG                    
## 25       DSCN7991.JPG                    
## 26       DSCN7992.JPG Chocolate Lily   CL
## 27       DSCN7999.JPG Chocolate Lily   CL
## 28       DSCN8000.JPG                    
## 29       DSCN8002.JPG                    
## 30       DSCN8004.JPG Chocolate Lily   CL
## 31       DSCN8005.JPG Chocolate Lily   CL
## 32       DSCN8006.JPG Chocolate Lily   CL
## 33       DSCN8007.JPG Chocolate Lily   CL
## 34       DSCN8008.JPG                    
## 35       DSCN8009.JPG                    
## 36       DSCN8011.JPG                    
## 37       DSCN8012.JPG                    
## 38       DSCN8013.JPG                    
## 39       DSCN8014.JPG  Monkey Flower     
## 40       DSCN8017.JPG  Monkey Flower     
## 41       DSCN8018.JPG                    
## 42       DSCN8019.JPG                    
## 43       DSCN8020.JPG                    
## 44       DSCN8021.JPG                    
## 45       DSCN8023.JPG                    
## 46       DSCN8024.JPG                    
## 47       DSCN8025.JPG                    
## 48       DSCN8026.JPG                    
## 49       DSCN8027.JPG                    
## 50       DSCN8030.JPG                    
## 51       DSCN8031.JPG                    
## 52       DSCN8032.JPG                    
## 53       DSCN8034.JPG                    
## 54       DSCN8036.JPG                    
## 55       DSCN8038.JPG                    
## 56       DSCN8039.JPG                    
## 57       DSCN8040.JPG                    
## 58       DSCN8041.JPG                    
## 59       DSCN8042.JPG                    
## 60       DSCN8044.JPG                    
## 61       DSCN8045.JPG                    
## 62       DSCN8046.JPG                    
## 63       DSCN8047.JPG                    
## 64       DSCN8048.JPG                    
## 65       DSCN8050.JPG                    
## 66       DSCN8051.JPG                    
## 67       DSCN8052.JPG                    
## 68       DSCN8053.JPG                    
## 69       DSCN8054.JPG                    
## 70       DSCN8055.JPG                    
## 71       DSCN8056.JPG                    
## 72       DSCN8057.JPG                    
## 73       DSCN8058.JPG                    
## 74       DSCN8059.JPG                    
## 75       DSCN8060.JPG                    
## 76       DSCN8061.JPG                    
## 77       DSCN8062.JPG                    
## 78       DSCN8063.JPG                    
## 79       DSCN8064.JPG                    
## 80       DSCN8065.JPG                    
## 81       DSCN8066.JPG                    
## 82  DSCN8067 copy.JPG                    
## 83       DSCN8067.JPG                    
## 84       DSCN8068.JPG                    
## 85       DSCN8069.JPG                    
## 86       DSCN8070.JPG                    
## 87       DSCN8071.JPG                    
## 88       DSCN8072.JPG                    
## 89       DSCN8073.JPG                    
## 90  DSCN8074 copy.JPG                    
## 91       DSCN8074.JPG                    
## 92  DSCN8076 copy.JPG                    
## 93       DSCN8076.JPG                    
## 94       DSCN8079.JPG                    
## 95       DSCN8080.JPG                    
## 96       DSCN8082.JPG                    
## 97       DSCN8084.JPG                    
## 98       DSCN8085.JPG                    
## 99       DSCN8088.JPG                    
## 100      DSCN8089.JPG                    
## 101      DSCN8091.JPG                    
## 102      DSCN8092.JPG                    
## 103      DSCN8094.JPG                    
## 104 DSCN8095 copy.JPG                    
## 105      DSCN8095.JPG                    
## 106      DSCN8097.JPG                    
## 107      DSCN8098.JPG                    
## 108      DSCN8099.JPG                    
## 109      DSCN8100.JPG                    
## 110      DSCN8101.JPG                    
## 111      DSCN8102.JPG                    
## 112      DSCN8103.JPG                    
## 113      DSCN8104.JPG                    
## 114      DSCN8105.JPG                    
## 115      DSCN8107.JPG                    
## 116      DSCN8108.JPG                    
## 117      DSCN8109.JPG                    
## 118      DSCN8110.JPG                    
## 119      DSCN8111.JPG                    
## 120      DSCN8112.JPG                    
## 121      DSCN8114.JPG                    
## 122      DSCN8115.JPG                    
## 123      DSCN8117.JPG                    
## 124      DSCN8118.JPG                    
## 125      DSCN8119.JPG                    
## 126      DSCN8120.JPG                    
## 127      DSCN8121.JPG                    
## 128      DSCN8122.JPG                    
## 129      DSCN8123.JPG                    
## 130      DSCN8124.JPG                    
## 131      DSCN8128.JPG                    
## 132      DSCN8131.JPG                    
## 133      DSCN8132.JPG                    
## 134      DSCN8133.JPG                    
## 135      DSCN8134.JPG                    
## 136      DSCN8135.JPG                    
## 137      DSCN8136.JPG                    
## 138      DSCN8137.JPG                    
## 139      DSCN8138.JPG                    
## 140      DSCN8141.JPG                    
## 141      DSCN8142.JPG                    
## 142      DSCN8143.JPG                    
## 143      DSCN8146.JPG                    
## 144      DSCN8147.JPG                    
## 145      DSCN8148.JPG                    
## 146      DSCN8149.JPG                    
## 147      DSCN8150.JPG                    
## 148      DSCN8151.JPG                    
## 149      DSCN8152.JPG                    
## 150      DSCN8153.JPG                    
## 151      DSCN8154.JPG                    
## 152      DSCN8156.JPG                    
## 153      DSCN8157.JPG                    
## 154      DSCN8158.JPG                    
## 155      DSCN8161.JPG                    
## 156      DSCN8162.JPG                    
## 157      DSCN8163.JPG                    
## 158      DSCN8164.JPG                    
## 159      DSCN8165.JPG                    
## 160      DSCN8167.JPG                    
## 161      DSCN8168.JPG                    
## 162      DSCN8169.JPG                    
## 163      DSCN8170.JPG                    
## 164      DSCN8171.JPG                    
## 165      DSCN8172.JPG                    
## 166      DSCN8174.JPG                    
## 167      DSCN8175.JPG                    
## 168      DSCN8176.JPG                    
## 169      DSCN8177.JPG                    
## 170      DSCN8180.JPG                    
## 171      DSCN8182.JPG                    
## 172      DSCN8183.JPG                    
## 173      DSCN8184.JPG                    
## 174      DSCN8185.JPG                    
## 175      DSCN8188.JPG                    
## 176      DSCN8189.JPG                    
## 177      DSCN8191.JPG                    
## 178      DSCN8192.JPG                    
## 179      DSCN8196.JPG                    
## 180      DSCN8198.JPG                    
## 181      DSCN8199.JPG                    
## 182      DSCN8200.JPG                    
## 183      DSCN8201.JPG                    
## 184      DSCN8202.JPG                    
## 185      DSCN8203.JPG                    
## 186      DSCN8204.JPG                    
## 187      DSCN8205.JPG                    
## 188      DSCN8206.JPG                    
## 189      DSCN8207.JPG                    
## 190      DSCN8208.JPG                    
## 191      DSCN8209.JPG                    
## 192      DSCN8211.JPG                    
## 193      DSCN8212.JPG                    
## 194      DSCN8213.JPG                    
## 195      DSCN8215.JPG                    
## 196      DSCN8216.JPG                    
## 197      DSCN8217.JPG                    
## 198      DSCN8218.JPG                    
## 199      DSCN8219.JPG                    
## 200      DSCN8220.JPG                    
## 201      DSCN8221.JPG                    
## 202      DSCN8222.JPG                    
## 203      DSCN8223.JPG                    
## 204      DSCN8225.JPG                    
## 205      DSCN8227.JPG                    
## 206      DSCN8229.JPG                    
## 207      DSCN8230.JPG                    
## 208      DSCN8231.JPG                    
## 209      DSCN8232.JPG                    
## 210      DSCN8234.JPG                    
## 211      DSCN8236.JPG                    
## 212      DSCN8237.JPG                    
## 213      DSCN8238.JPG                    
## 214      DSCN8239.JPG                    
## 215      DSCN8242.JPG                    
## 216      DSCN8244.JPG                    
## 217      DSCN8245.JPG                    
## 218      DSCN8246.JPG                    
## 219      DSCN8247.JPG                    
## 220      DSCN8248.JPG                    
## 221      DSCN8251.JPG                    
## 222      DSCN8255.JPG                    
## 223      DSCN8258.JPG                    
## 224      DSCN8259.JPG                    
## 225      DSCN8275.JPG                    
## 226      DSCN8276.JPG                    
## 227      DSCN8277.JPG                    
## 228      DSCN8280.JPG                    
## 229      DSCN8281.JPG                    
## 230      DSCN8283.JPG                    
## 231      DSCN8285.JPG                    
## 232      DSCN8287.JPG                    
## 233      DSCN8288.JPG                    
## 234      DSCN8289.JPG                    
## 235      DSCN8290.JPG                    
## 236      DSCN8292.JPG                    
## 237      DSCN8293.JPG                    
## 238      DSCN8294.JPG                    
## 239      DSCN8295.JPG                    
## 240      DSCN8296.JPG                    
## 241      DSCN8298.JPG                    
## 242      DSCN8299.JPG                    
## 243      DSCN8304.JPG                    
## 244      DSCN8306.JPG                    
## 245      DSCN8308.JPG                    
## 246      DSCN8309.JPG                    
## 247      DSCN8310.JPG                    
## 248      DSCN8312.JPG                    
## 249      DSCN8314.JPG                    
## 250      DSCN8315.JPG                    
## 251      DSCN8316.JPG                    
## 252      DSCN8317.JPG                    
## 253      DSCN8320.JPG                    
## 254      DSCN8324.JPG                    
## 255      DSCN8328.JPG                    
## 256      DSCN8330.JPG                    
## 257      DSCN8333.JPG                    
## 258      DSCN8334.JPG

3.4 Sort data by Image

class(exif)
## [1] "data.frame"
exif_sort <- exif[order(exif$Image, decreasing = FALSE), ]

4 {jsonlite} create json object from all data

exif_json <- toJSON(exif_sort)
exif_json
## [{"Image":"DSCN7961.JPG","Date":"2022-04-14 14:21:41","Exposure":0.002,"F-Stop":8.8,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7962.JPG","Date":"2022-04-14 14:21:47","Exposure":0.002,"F-Stop":9.1,"ISO":125,"Focal":13,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7963.JPG","Date":"2022-04-14 14:21:54","Exposure":0.002,"F-Stop":9.1,"ISO":125,"Focal":13,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7965.JPG","Date":"2022-04-14 14:50:57","Longitude":-123.3453,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7966.JPG","Date":"2022-04-14 14:51:05","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7967.JPG","Date":"2022-04-14 14:51:11","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7968.JPG","Date":"2022-04-14 14:51:13","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7969.JPG","Date":"2022-04-14 14:51:15","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7970 copy.JPG","Date":"2022-04-14 14:51:16","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7970.JPG","Date":"2022-04-14 14:51:16","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7971.JPG","Date":"2022-04-14 14:52:28","Longitude":-123.3454,"Latitude":48.4929,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7973.JPG","Date":"2022-04-14 14:52:30","Longitude":-123.3454,"Latitude":48.4929,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7975.JPG","Date":"2022-04-14 14:52:41","Longitude":-123.3453,"Latitude":48.4929,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"ML","Name":"Miners Lettuce","Location":"Mt. Douglas"},{"Image":"DSCN7977.JPG","Date":"2022-04-14 14:53:54","Longitude":-123.3454,"Latitude":48.4931,"Exposure":0.0125,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7978.JPG","Date":"2022-04-14 14:54:26","Longitude":-123.3455,"Latitude":48.4931,"Exposure":0.002,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"LF","Name":"Licorice Fern","Location":"Mt. Douglas"},{"Image":"DSCN7979.JPG","Date":"2022-04-14 14:54:29","Longitude":-123.3454,"Latitude":48.4931,"Exposure":0.01,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"LF","Name":"Licorice Fern","Location":"Mt. Douglas"},{"Image":"DSCN7980.JPG","Date":"2022-04-14 14:54:42","Longitude":-123.3455,"Latitude":48.4931,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7982.JPG","Date":"2022-04-14 14:54:58","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7983.JPG","Date":"2022-04-14 14:55:04","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7984.JPG","Date":"2022-04-14 14:55:09","Longitude":-123.3457,"Latitude":48.4932,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7985.JPG","Date":"2022-04-14 14:55:12","Longitude":-123.3457,"Latitude":48.4932,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7987.JPG","Date":"2022-04-14 14:56:31","Longitude":-123.3454,"Latitude":48.493,"Exposure":0.0062,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7988.JPG","Date":"2022-04-14 14:56:33","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.0062,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7989.JPG","Date":"2022-04-14 14:56:36","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.005,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7991.JPG","Date":"2022-04-14 14:56:47","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.004,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN7992.JPG","Date":"2022-04-14 14:57:21","Longitude":-123.3456,"Latitude":48.4932,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN7999.JPG","Date":"2022-04-14 14:58:25","Longitude":-123.3457,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8000.JPG","Date":"2022-04-14 14:58:27","Longitude":-123.3457,"Latitude":48.4931,"Exposure":0.02,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8002.JPG","Date":"2022-04-14 14:58:35","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.02,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8004.JPG","Date":"2022-04-14 14:58:53","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.02,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8005.JPG","Date":"2022-04-14 14:59:07","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8006.JPG","Date":"2022-04-14 14:59:16","Longitude":-123.3456,"Latitude":48.4932,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8007.JPG","Date":"2022-04-14 14:59:17","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8008.JPG","Date":"2022-04-14 15:00:58","Longitude":-123.3457,"Latitude":48.4929,"Exposure":0.002,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8009.JPG","Date":"2022-04-14 15:01:04","Longitude":-123.3457,"Latitude":48.4929,"Exposure":0.0016,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8011.JPG","Date":"2022-04-14 15:01:37","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.0025,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8012.JPG","Date":"2022-04-14 15:01:40","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.0025,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8013.JPG","Date":"2022-04-14 15:01:56","Longitude":-123.3457,"Latitude":48.493,"Exposure":0.005,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8014.JPG","Date":"2022-04-14 15:02:51","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.001,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN8017.JPG","Date":"2022-04-14 15:03:24","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN8018.JPG","Date":"2022-04-14 15:03:25","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8019.JPG","Date":"2022-04-14 15:03:26","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8020.JPG","Date":"2022-04-14 15:03:42","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0016,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8021.JPG","Date":"2022-04-14 15:04:05","Longitude":-123.3458,"Latitude":48.4928,"Exposure":0.0012,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8023.JPG","Date":"2022-04-14 15:04:31","Longitude":-123.3458,"Latitude":48.4928,"Exposure":0.0025,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8024.JPG","Date":"2022-04-14 15:04:46","Longitude":-123.3458,"Latitude":48.4928,"Exposure":0.0012,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8025.JPG","Date":"2022-04-14 15:04:47","Longitude":-123.3458,"Latitude":48.4928,"Exposure":0.0016,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8026.JPG","Date":"2022-04-14 15:06:58","Longitude":-123.346,"Latitude":48.4928,"Exposure":0.0025,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8027.JPG","Date":"2022-04-14 15:07:27","Longitude":-123.3457,"Latitude":48.4928,"Exposure":0.0031,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8030.JPG","Date":"2022-04-14 15:07:58","Longitude":-123.3457,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8031.JPG","Date":"2022-04-14 15:08:37","Longitude":-123.3457,"Latitude":48.4928,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8032.JPG","Date":"2022-04-14 15:08:42","Longitude":-123.3457,"Latitude":48.4928,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8034.JPG","Date":"2022-04-14 15:09:19","Longitude":-123.3457,"Latitude":48.4928,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8036.JPG","Date":"2022-04-14 15:09:21","Longitude":-123.3457,"Latitude":48.4928,"Exposure":0.0025,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8038.JPG","Date":"2022-04-14 15:09:25","Longitude":-123.3457,"Latitude":48.4928,"Exposure":0.0025,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8039.JPG","Date":"2022-04-14 15:10:19","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0062,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8040.JPG","Date":"2022-04-14 15:10:21","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0062,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8041.JPG","Date":"2022-04-14 15:10:25","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8042.JPG","Date":"2022-04-14 15:10:26","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8044.JPG","Date":"2022-04-14 15:10:35","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8045.JPG","Date":"2022-04-14 15:10:37","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8046.JPG","Date":"2022-04-14 15:10:39","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8047.JPG","Date":"2022-04-14 15:10:44","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0025,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8048.JPG","Date":"2022-04-14 15:14:35","Longitude":-123.3456,"Latitude":48.4929,"Exposure":0.0031,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8050.JPG","Date":"2022-04-14 15:14:40","Longitude":-123.3458,"Latitude":48.4928,"Exposure":0.0031,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8051.JPG","Date":"2022-04-14 15:14:44","Longitude":-123.3459,"Latitude":48.4928,"Exposure":0.0025,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8052.JPG","Date":"2022-04-14 15:40:05","Longitude":-123.3458,"Latitude":48.493,"Exposure":0.0167,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8053.JPG","Date":"2022-04-14 15:40:15","Longitude":-123.3461,"Latitude":48.4928,"Exposure":0.005,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8054.JPG","Date":"2022-04-14 15:45:12","Exposure":0.002,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8055.JPG","Date":"2022-04-14 15:45:15","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.001,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8056.JPG","Date":"2022-04-14 15:45:17","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8057.JPG","Date":"2022-04-14 15:45:20","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8058.JPG","Date":"2022-04-14 15:46:11","Longitude":-123.3462,"Latitude":48.4928,"Exposure":0.0008,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8059.JPG","Date":"2022-04-14 15:46:14","Longitude":-123.3462,"Latitude":48.4928,"Exposure":0.0016,"F-Stop":8.2,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8060.JPG","Date":"2022-04-14 15:47:56","Longitude":-123.3464,"Latitude":48.4929,"Exposure":0.004,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8061.JPG","Date":"2022-04-14 15:48:07","Longitude":-123.3464,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8062.JPG","Date":"2022-04-14 15:48:15","Longitude":-123.3464,"Latitude":48.4929,"Exposure":0.0007,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8063.JPG","Date":"2022-04-14 15:48:28","Longitude":-123.3464,"Latitude":48.4929,"Exposure":0.0025,"F-Stop":8.2,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8064.JPG","Date":"2022-04-14 15:49:12","Longitude":-123.3465,"Latitude":48.493,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8065.JPG","Date":"2022-04-14 15:53:39","Longitude":-123.3466,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8066.JPG","Date":"2022-04-14 15:53:43","Longitude":-123.3468,"Latitude":48.4929,"Exposure":0.0016,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8067 copy.JPG","Date":"2022-04-14 15:53:46","Longitude":-123.3468,"Latitude":48.4929,"Exposure":0.0016,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8067.JPG","Date":"2022-04-14 15:53:46","Longitude":-123.3468,"Latitude":48.4929,"Exposure":0.0016,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8068.JPG","Date":"2022-04-14 15:53:52","Longitude":-123.3468,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8069.JPG","Date":"2022-04-14 15:53:55","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8070.JPG","Date":"2022-04-14 15:53:59","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8071.JPG","Date":"2022-04-14 15:55:14","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0016,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8072.JPG","Date":"2022-04-14 15:55:17","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0025,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8073.JPG","Date":"2022-04-14 15:55:49","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0016,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8074 copy.JPG","Date":"2022-04-14 15:56:06","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0031,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8074.JPG","Date":"2022-04-14 15:56:06","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0031,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8076 copy.JPG","Date":"2022-04-14 15:56:20","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.008,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8076.JPG","Date":"2022-04-14 15:56:20","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.008,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8079.JPG","Date":"2022-04-14 15:57:04","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.002,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8080.JPG","Date":"2022-04-14 15:57:29","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8082.JPG","Date":"2022-04-14 15:57:52","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.002,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8084.JPG","Date":"2022-04-14 15:58:14","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8085.JPG","Date":"2022-04-14 15:58:16","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8088.JPG","Date":"2022-04-14 16:02:18","Longitude":-123.3469,"Latitude":48.493,"Exposure":0.005,"F-Stop":4.4,"ISO":125,"Focal":11,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8089.JPG","Date":"2022-04-14 16:02:22","Longitude":-123.3469,"Latitude":48.493,"Exposure":0.0062,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8091.JPG","Date":"2022-04-14 16:03:26","Longitude":-123.3467,"Latitude":48.493,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8092.JPG","Date":"2022-04-14 16:03:38","Longitude":-123.3467,"Latitude":48.493,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8094.JPG","Date":"2022-04-14 16:04:20","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8095 copy.JPG","Date":"2022-04-14 16:04:25","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8095.JPG","Date":"2022-04-14 16:04:25","Longitude":-123.3468,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8097.JPG","Date":"2022-04-14 16:06:02","Longitude":-123.3465,"Latitude":48.4931,"Exposure":0.0012,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8098.JPG","Date":"2022-04-14 16:06:03","Longitude":-123.3465,"Latitude":48.4931,"Exposure":0.0012,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8099.JPG","Date":"2022-04-14 16:06:07","Longitude":-123.3466,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8100.JPG","Date":"2022-04-14 16:06:12","Longitude":-123.3466,"Latitude":48.4929,"Exposure":0.0012,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8101.JPG","Date":"2022-04-14 16:06:16","Longitude":-123.3466,"Latitude":48.4929,"Exposure":0.0025,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8102.JPG","Date":"2022-04-14 16:11:02","Longitude":-123.3465,"Latitude":48.493,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8103.JPG","Date":"2022-04-14 16:11:14","Longitude":-123.3463,"Latitude":48.4928,"Exposure":0.0008,"F-Stop":4.1,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8104.JPG","Date":"2022-04-14 16:11:30","Longitude":-123.3463,"Latitude":48.4928,"Exposure":0.001,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8105.JPG","Date":"2022-04-14 16:11:46","Longitude":-123.3463,"Latitude":48.4928,"Exposure":0.0012,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8107.JPG","Date":"2022-04-14 16:15:18","Longitude":-123.3463,"Latitude":48.4927,"Exposure":0.0008,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8108.JPG","Date":"2022-04-14 16:19:37","Longitude":-123.3464,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8109.JPG","Date":"2022-04-14 16:19:40","Longitude":-123.3464,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8110.JPG","Date":"2022-04-14 16:26:36","Longitude":-123.3449,"Latitude":48.4924,"Exposure":0.0125,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8111.JPG","Date":"2022-04-14 16:26:40","Longitude":-123.345,"Latitude":48.4924,"Exposure":0.01,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8112.JPG","Date":"2022-04-14 16:26:46","Longitude":-123.345,"Latitude":48.4924,"Exposure":0.001,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8114.JPG","Date":"2022-04-14 16:26:49","Longitude":-123.345,"Latitude":48.4924,"Exposure":0.0012,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8115.JPG","Date":"2022-04-14 16:32:13","Longitude":-123.3448,"Latitude":48.4919,"Exposure":0.001,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8117.JPG","Date":"2022-04-14 16:32:40","Longitude":-123.3448,"Latitude":48.4919,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8118.JPG","Date":"2022-04-14 16:34:46","Longitude":-123.3449,"Latitude":48.4919,"Exposure":0.002,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8119.JPG","Date":"2022-04-14 16:34:50","Longitude":-123.345,"Latitude":48.4917,"Exposure":0.001,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8120.JPG","Date":"2022-04-14 16:34:56","Longitude":-123.345,"Latitude":48.4918,"Exposure":0.0016,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8121.JPG","Date":"2022-04-14 16:35:05","Longitude":-123.3449,"Latitude":48.4918,"Exposure":0.0016,"F-Stop":8.3,"ISO":125,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8122.JPG","Date":"2022-04-14 16:35:10","Longitude":-123.3449,"Latitude":48.4918,"Exposure":0.001,"F-Stop":8.8,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8123.JPG","Date":"2022-04-14 16:35:12","Longitude":-123.3449,"Latitude":48.4917,"Exposure":0.001,"F-Stop":8.8,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8124.JPG","Date":"2022-04-14 16:35:13","Longitude":-123.3449,"Latitude":48.4917,"Exposure":0.001,"F-Stop":8.8,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8128.JPG","Date":"2022-04-14 16:38:11","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8131.JPG","Date":"2022-04-14 16:38:21","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8132.JPG","Date":"2022-04-14 16:38:24","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8133.JPG","Date":"2022-04-14 16:38:26","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8134.JPG","Date":"2022-04-14 16:38:28","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8135.JPG","Date":"2022-04-14 16:38:29","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0031,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8136.JPG","Date":"2022-04-14 16:38:46","Longitude":-123.345,"Latitude":48.492,"Exposure":0.0031,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8137.JPG","Date":"2022-04-14 16:39:08","Longitude":-123.345,"Latitude":48.4921,"Exposure":0.0025,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8138.JPG","Date":"2022-04-14 16:39:12","Longitude":-123.345,"Latitude":48.4921,"Exposure":0.0031,"F-Stop":4.7,"ISO":125,"Focal":16.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8141.JPG","Date":"2022-04-14 16:39:56","Longitude":-123.345,"Latitude":48.4921,"Exposure":0.001,"F-Stop":4.1,"ISO":125,"Focal":4.7,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8142.JPG","Date":"2022-04-14 16:39:57","Longitude":-123.345,"Latitude":48.4921,"Exposure":0.001,"F-Stop":4.1,"ISO":125,"Focal":4.7,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8143.JPG","Date":"2022-04-14 16:40:07","Longitude":-123.345,"Latitude":48.4921,"Exposure":0.001,"F-Stop":4.1,"ISO":125,"Focal":4.7,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8146.JPG","Date":"2022-04-14 16:40:13","Longitude":-123.345,"Latitude":48.4921,"Exposure":0.001,"F-Stop":4.1,"ISO":125,"Focal":4.7,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8147.JPG","Date":"2022-04-14 16:41:03","Longitude":-123.3449,"Latitude":48.4923,"Exposure":0.001,"F-Stop":2.8,"ISO":125,"Focal":4.7,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8148.JPG","Date":"2022-04-14 16:41:22","Longitude":-123.3448,"Latitude":48.4923,"Exposure":0.001,"F-Stop":4.1,"ISO":125,"Focal":4.7,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8149.JPG","Date":"2022-04-14 16:50:02","Longitude":-123.345,"Latitude":48.4925,"Exposure":0.04,"F-Stop":4.4,"ISO":400,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8150.JPG","Date":"2022-04-14 16:50:29","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8151.JPG","Date":"2022-04-14 16:50:35","Longitude":-123.3428,"Latitude":48.4962,"Exposure":0.05,"F-Stop":4.2,"ISO":400,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8152.JPG","Date":"2022-04-14 16:50:51","Longitude":-123.3427,"Latitude":48.4962,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8153.JPG","Date":"2022-04-14 16:51:42","Longitude":-123.3425,"Latitude":48.4962,"Exposure":0.0333,"F-Stop":4.2,"ISO":360,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8154.JPG","Date":"2022-04-14 16:51:48","Longitude":-123.3425,"Latitude":48.4962,"Exposure":0.0333,"F-Stop":4.2,"ISO":360,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8156.JPG","Date":"2022-04-14 16:52:24","Longitude":-123.3422,"Latitude":48.4961,"Exposure":0.0062,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8157.JPG","Date":"2022-04-14 16:52:47","Longitude":-123.3423,"Latitude":48.4961,"Exposure":0.0333,"F-Stop":4.2,"ISO":220,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8158.JPG","Date":"2022-04-14 16:52:51","Longitude":-123.3423,"Latitude":48.4961,"Exposure":0.0333,"F-Stop":4.2,"ISO":220,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8161.JPG","Date":"2022-04-14 16:53:01","Longitude":-123.3424,"Latitude":48.4961,"Exposure":0.0333,"F-Stop":4.2,"ISO":160,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8162.JPG","Date":"2022-04-14 16:53:06","Longitude":-123.3424,"Latitude":48.4961,"Exposure":0.0333,"F-Stop":4.2,"ISO":160,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8163.JPG","Date":"2022-04-14 16:53:19","Longitude":-123.3423,"Latitude":48.4961,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8164.JPG","Date":"2022-04-14 16:53:23","Longitude":-123.3423,"Latitude":48.4961,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8165.JPG","Date":"2022-04-14 16:53:28","Longitude":-123.3423,"Latitude":48.4961,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8167.JPG","Date":"2022-04-14 16:53:59","Longitude":-123.3422,"Latitude":48.4961,"Exposure":0.0062,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8168.JPG","Date":"2022-04-14 16:54:04","Longitude":-123.3422,"Latitude":48.4961,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8169.JPG","Date":"2022-04-14 16:54:07","Longitude":-123.3422,"Latitude":48.4961,"Exposure":0.005,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8170.JPG","Date":"2022-04-14 16:55:51","Longitude":-123.342,"Latitude":48.4962,"Exposure":0.0062,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8171.JPG","Date":"2022-04-14 16:56:04","Longitude":-123.3422,"Latitude":48.4964,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8172.JPG","Date":"2022-04-14 16:56:10","Longitude":-123.3422,"Latitude":48.4964,"Exposure":0.0333,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8174.JPG","Date":"2022-04-14 16:56:16","Longitude":-123.3422,"Latitude":48.4964,"Exposure":0.005,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8175.JPG","Date":"2022-04-14 16:56:32","Longitude":-123.3421,"Latitude":48.4963,"Exposure":0.01,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8176.JPG","Date":"2022-04-14 16:57:06","Longitude":-123.3425,"Latitude":48.4963,"Exposure":0.008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8177.JPG","Date":"2022-04-14 16:57:09","Longitude":-123.3425,"Latitude":48.4963,"Exposure":0.0125,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8180.JPG","Date":"2022-04-14 16:58:00","Longitude":-123.3425,"Latitude":48.4962,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8182.JPG","Date":"2022-04-14 16:58:07","Longitude":-123.3425,"Latitude":48.4962,"Exposure":0.01,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8183.JPG","Date":"2022-04-14 16:58:13","Longitude":-123.3425,"Latitude":48.4962,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8184.JPG","Date":"2022-04-14 17:01:16","Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8185.JPG","Date":"2022-04-14 17:01:40","Longitude":-123.3423,"Latitude":48.4963,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8188.JPG","Date":"2022-04-14 17:02:02","Longitude":-123.3424,"Latitude":48.4963,"Exposure":0.01,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8189.JPG","Date":"2022-04-14 17:02:14","Longitude":-123.3423,"Latitude":48.4963,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8191.JPG","Date":"2022-04-14 17:02:19","Longitude":-123.3423,"Latitude":48.4962,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8192.JPG","Date":"2022-04-14 17:02:38","Longitude":-123.3423,"Latitude":48.4962,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8196.JPG","Date":"2022-04-14 17:02:51","Longitude":-123.3423,"Latitude":48.4963,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8198.JPG","Date":"2022-04-14 17:03:05","Longitude":-123.3423,"Latitude":48.4962,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8199.JPG","Date":"2022-04-14 17:04:38","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8200.JPG","Date":"2022-04-14 17:05:06","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.004,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8201.JPG","Date":"2022-04-14 17:05:10","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8202.JPG","Date":"2022-04-14 17:05:12","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8203.JPG","Date":"2022-04-14 17:05:14","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.0125,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8204.JPG","Date":"2022-04-14 17:05:16","Longitude":-123.3428,"Latitude":48.4963,"Exposure":0.004,"F-Stop":4.2,"ISO":125,"Focal":6.6,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8205.JPG","Date":"2022-04-14 17:16:22","Longitude":-123.3428,"Latitude":48.4964,"Exposure":0.0333,"F-Stop":2.8,"ISO":250,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8206.JPG","Date":"2022-04-14 17:16:27","Longitude":-123.3428,"Latitude":48.4964,"Exposure":0.0333,"F-Stop":2.8,"ISO":180,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8207.JPG","Date":"2022-04-14 17:16:30","Longitude":-123.3427,"Latitude":48.4964,"Exposure":0.0025,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8208.JPG","Date":"2022-04-14 17:16:35","Longitude":-123.3427,"Latitude":48.4964,"Exposure":0.0333,"F-Stop":2.8,"ISO":160,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8209.JPG","Date":"2022-04-14 17:26:20","Exposure":0.02,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8211.JPG","Date":"2022-04-14 17:26:30","Longitude":-123.3382,"Latitude":48.491,"Exposure":0.02,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8212.JPG","Date":"2022-04-14 17:26:35","Longitude":-123.3382,"Latitude":48.491,"Exposure":0.02,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8213.JPG","Date":"2022-04-14 17:26:36","Longitude":-123.3382,"Latitude":48.491,"Exposure":0.02,"F-Stop":4.4,"ISO":125,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8215.JPG","Date":"2022-04-14 17:26:48","Longitude":-123.3383,"Latitude":48.491,"Exposure":0.0333,"F-Stop":4.4,"ISO":220,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8216.JPG","Date":"2022-04-14 17:26:50","Longitude":-123.3383,"Latitude":48.491,"Exposure":0.0333,"F-Stop":4.4,"ISO":250,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8217.JPG","Date":"2022-04-14 17:26:56","Longitude":-123.3383,"Latitude":48.4909,"Exposure":0.0333,"F-Stop":4.4,"ISO":320,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8218.JPG","Date":"2022-04-14 17:27:15","Longitude":-123.3382,"Latitude":48.4909,"Exposure":0.0333,"F-Stop":4.4,"ISO":250,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8219.JPG","Date":"2022-04-14 17:27:29","Longitude":-123.3382,"Latitude":48.4909,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8220.JPG","Date":"2022-04-14 17:27:37","Longitude":-123.3382,"Latitude":48.4909,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8221.JPG","Date":"2022-04-14 17:28:25","Longitude":-123.338,"Latitude":48.4909,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8222.JPG","Date":"2022-04-14 17:28:32","Longitude":-123.338,"Latitude":48.4909,"Exposure":0.0333,"F-Stop":2.8,"ISO":180,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8223.JPG","Date":"2022-04-14 17:28:40","Longitude":-123.338,"Latitude":48.491,"Exposure":0.01,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8225.JPG","Date":"2022-04-14 17:28:49","Longitude":-123.338,"Latitude":48.491,"Exposure":0.02,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8227.JPG","Date":"2022-04-14 17:29:10","Longitude":-123.3381,"Latitude":48.491,"Exposure":0.0333,"F-Stop":4.2,"ISO":140,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8229.JPG","Date":"2022-04-14 17:29:29","Longitude":-123.3382,"Latitude":48.4911,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8230.JPG","Date":"2022-04-14 17:29:48","Longitude":-123.3383,"Latitude":48.4911,"Exposure":0.01,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8231.JPG","Date":"2022-04-14 17:29:52","Longitude":-123.3384,"Latitude":48.4912,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8232.JPG","Date":"2022-04-14 17:30:10","Longitude":-123.3384,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8234.JPG","Date":"2022-04-14 17:30:38","Longitude":-123.3385,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":250,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8236.JPG","Date":"2022-04-14 17:31:00","Longitude":-123.3387,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8237.JPG","Date":"2022-04-14 17:31:05","Longitude":-123.3387,"Latitude":48.4914,"Exposure":0.005,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8238.JPG","Date":"2022-04-14 17:31:27","Longitude":-123.3387,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8239.JPG","Date":"2022-04-14 17:32:05","Longitude":-123.3389,"Latitude":48.4913,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8242.JPG","Date":"2022-04-14 17:32:27","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":320,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8244.JPG","Date":"2022-04-14 17:32:35","Longitude":-123.3389,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8245.JPG","Date":"2022-04-14 17:32:42","Longitude":-123.3389,"Latitude":48.4914,"Exposure":0.05,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8246.JPG","Date":"2022-04-14 17:32:43","Longitude":-123.3389,"Latitude":48.4914,"Exposure":0.05,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8247.JPG","Date":"2022-04-14 17:32:48","Longitude":-123.3389,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8248.JPG","Date":"2022-04-14 17:33:03","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8251.JPG","Date":"2022-04-14 17:33:10","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8255.JPG","Date":"2022-04-14 17:33:17","Longitude":-123.339,"Latitude":48.4913,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8258.JPG","Date":"2022-04-14 17:33:29","Longitude":-123.339,"Latitude":48.4913,"Exposure":0.0333,"F-Stop":4.2,"ISO":360,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8259.JPG","Date":"2022-04-14 17:33:31","Longitude":-123.339,"Latitude":48.4913,"Exposure":0.0333,"F-Stop":4.2,"ISO":360,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8275.JPG","Date":"2022-04-14 17:34:19","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":200,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8276.JPG","Date":"2022-04-14 17:34:25","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8277.JPG","Date":"2022-04-14 17:34:26","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8280.JPG","Date":"2022-04-14 17:34:49","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8281.JPG","Date":"2022-04-14 17:34:55","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8283.JPG","Date":"2022-04-14 17:35:15","Longitude":-123.339,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":200,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8285.JPG","Date":"2022-04-14 17:36:10","Longitude":-123.3394,"Latitude":48.4914,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8287.JPG","Date":"2022-04-14 17:36:29","Longitude":-123.3394,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8288.JPG","Date":"2022-04-14 17:36:36","Longitude":-123.3394,"Latitude":48.4914,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8289.JPG","Date":"2022-04-14 17:36:45","Longitude":-123.3393,"Latitude":48.4913,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8290.JPG","Date":"2022-04-14 17:36:51","Longitude":-123.3393,"Latitude":48.4913,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8292.JPG","Date":"2022-04-14 17:37:00","Longitude":-123.3392,"Latitude":48.4913,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8293.JPG","Date":"2022-04-14 17:37:30","Longitude":-123.3395,"Latitude":48.4913,"Exposure":0.0667,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8294.JPG","Date":"2022-04-14 17:37:31","Longitude":-123.3395,"Latitude":48.4913,"Exposure":0.0667,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8295.JPG","Date":"2022-04-14 17:38:40","Longitude":-123.3398,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8296.JPG","Date":"2022-04-14 17:38:45","Longitude":-123.3398,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8298.JPG","Date":"2022-04-14 17:39:09","Longitude":-123.3398,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":280,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8299.JPG","Date":"2022-04-14 17:39:11","Longitude":-123.3398,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":160,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8304.JPG","Date":"2022-04-14 17:39:47","Longitude":-123.3399,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":320,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8306.JPG","Date":"2022-04-14 17:39:56","Longitude":-123.3399,"Latitude":48.4913,"Exposure":0.0333,"F-Stop":4.2,"ISO":360,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8308.JPG","Date":"2022-04-14 17:40:31","Longitude":-123.3401,"Latitude":48.4913,"Exposure":0.0667,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8309.JPG","Date":"2022-04-14 17:40:48","Longitude":-123.3401,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.2,"ISO":360,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8310.JPG","Date":"2022-04-14 17:41:33","Longitude":-123.34,"Latitude":48.491,"Exposure":0.04,"F-Stop":4.2,"ISO":400,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8312.JPG","Date":"2022-04-14 17:43:49","Longitude":-123.3399,"Latitude":48.491,"Exposure":0.005,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8314.JPG","Date":"2022-04-14 17:44:09","Longitude":-123.3404,"Latitude":48.4912,"Exposure":0.005,"F-Stop":4.2,"ISO":125,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8315.JPG","Date":"2022-04-14 17:44:26","Longitude":-123.3405,"Latitude":48.4912,"Exposure":0.1,"F-Stop":4.2,"ISO":450,"Focal":6.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8316.JPG","Date":"2022-04-14 17:44:39","Longitude":-123.3404,"Latitude":48.4911,"Exposure":0.04,"F-Stop":2.8,"ISO":400,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8317.JPG","Date":"2022-04-14 17:44:41","Longitude":-123.3404,"Latitude":48.4911,"Exposure":0.04,"F-Stop":2.8,"ISO":400,"Focal":4.3,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8320.JPG","Date":"2022-04-14 17:50:37","Longitude":-123.3398,"Latitude":48.4912,"Exposure":0.0333,"F-Stop":4.4,"ISO":220,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8324.JPG","Date":"2022-04-14 17:51:16","Longitude":-123.3397,"Latitude":48.4913,"Exposure":0.0333,"F-Stop":4.4,"ISO":400,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8328.JPG","Date":"2022-04-14 17:51:26","Longitude":-123.3397,"Latitude":48.4913,"Exposure":0.0333,"F-Stop":4.4,"ISO":220,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8330.JPG","Date":"2022-04-14 17:53:36","Longitude":-123.3391,"Latitude":48.4915,"Exposure":0.0667,"F-Stop":4.4,"ISO":400,"Focal":10.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8333.JPG","Date":"2022-04-14 17:57:30","Longitude":-123.3388,"Latitude":48.4913,"Exposure":0.0667,"F-Stop":4.8,"ISO":900,"Focal":18.1,"Desc":"","Name":"","Location":"Mt. Douglas"},{"Image":"DSCN8334.JPG","Date":"2022-04-14 17:57:58","Longitude":-123.339,"Latitude":48.4915,"Exposure":0.0333,"F-Stop":2.8,"ISO":200,"Focal":5.1,"Desc":"","Name":"","Location":"Mt. Douglas"}]
class(exif_json)
## [1] "json"

4.1 save all data as json file

write(exif_json, "./data/exif_json.json")

5 remove rows without name, using dplyr, before creating json file

# https://stackoverflow.com/questions/9126840/delete-rows-with-blank-values-in-one-particular-column
class(exif_sort)
## [1] "data.frame"
View(exif_sort)

# https://stackoverflow.com/questions/9126840/delete-rows-with-blank-values-in-one-particular-column
exif_sort_name_nona <- exif_sort[!(is.na(exif_sort$Name) | exif_sort$Name==""), ]

class(exif_sort_name_nona)
## [1] "data.frame"
View(exif_sort_name_nona)

5.1 Sort no NA data by Name before creating json file

exif_sort_name_nona_sort <- exif_sort_name_nona[order(exif_sort_name_nona$Name, decreasing = FALSE), ]
exif_sort_name_nona_sort
##                Image                Date Longitude Latitude   Exposure F-Stop
## 4       DSCN7965.JPG 2022-04-14 14:50:57 -123.3453 48.49260 0.00250000    4.9
## 5       DSCN7966.JPG 2022-04-14 14:51:05 -123.3452 48.49255 0.00250000    4.9
## 6       DSCN7967.JPG 2022-04-14 14:51:11 -123.3452 48.49252 0.00250000    4.9
## 7       DSCN7968.JPG 2022-04-14 14:51:13 -123.3452 48.49252 0.00250000    4.9
## 8       DSCN7969.JPG 2022-04-14 14:51:15 -123.3452 48.49256 0.00250000    4.9
## 9  DSCN7970 copy.JPG 2022-04-14 14:51:16 -123.3452 48.49258 0.00250000    4.9
## 10      DSCN7970.JPG 2022-04-14 14:51:16 -123.3452 48.49258 0.00250000    4.9
## 26      DSCN7992.JPG 2022-04-14 14:57:21 -123.3456 48.49316 0.02500000    4.2
## 27      DSCN7999.JPG 2022-04-14 14:58:25 -123.3457 48.49313 0.01666667    2.8
## 30      DSCN8004.JPG 2022-04-14 14:58:53 -123.3456 48.49305 0.02000000    2.8
## 31      DSCN8005.JPG 2022-04-14 14:59:07 -123.3456 48.49307 0.01666667    2.8
## 32      DSCN8006.JPG 2022-04-14 14:59:16 -123.3456 48.49316 0.01666667    2.8
## 33      DSCN8007.JPG 2022-04-14 14:59:17 -123.3456 48.49314 0.01666667    2.8
## 11      DSCN7971.JPG 2022-04-14 14:52:28 -123.3454 48.49294 0.02000000    4.2
## 14      DSCN7977.JPG 2022-04-14 14:53:54 -123.3454 48.49312 0.01250000    4.2
## 17      DSCN7980.JPG 2022-04-14 14:54:42 -123.3455 48.49312 0.00800000    4.2
## 15      DSCN7978.JPG 2022-04-14 14:54:26 -123.3455 48.49312 0.00200000    4.2
## 16      DSCN7979.JPG 2022-04-14 14:54:29 -123.3454 48.49313 0.01000000    4.2
## 13      DSCN7975.JPG 2022-04-14 14:52:41 -123.3453 48.49288 0.00800000    4.2
## 18      DSCN7982.JPG 2022-04-14 14:54:58 -123.3456 48.49306 0.01666667    4.2
## 19      DSCN7983.JPG 2022-04-14 14:55:04 -123.3456 48.49303 0.03333333    4.2
## 20      DSCN7984.JPG 2022-04-14 14:55:09 -123.3457 48.49317 0.03333333    4.2
## 21      DSCN7985.JPG 2022-04-14 14:55:12 -123.3457 48.49321 0.02500000    4.2
## 39      DSCN8014.JPG 2022-04-14 15:02:51 -123.3458 48.49294 0.00100000    2.8
## 40      DSCN8017.JPG 2022-04-14 15:03:24 -123.3458 48.49291 0.00080000    2.8
##    ISO Focal Desc           Name    Location
## 4  125  21.5   BF        Bee Fly Mt. Douglas
## 5  125  21.5   BF        Bee Fly Mt. Douglas
## 6  125  21.5   BF        Bee Fly Mt. Douglas
## 7  125  21.5   BF        Bee Fly Mt. Douglas
## 8  125  21.5   BF        Bee Fly Mt. Douglas
## 9  125  21.5   BF        Bee Fly Mt. Douglas
## 10 125  21.5   BF        Bee Fly Mt. Douglas
## 26 125   7.2   CL Chocolate Lily Mt. Douglas
## 27 125   5.1   CL Chocolate Lily Mt. Douglas
## 30 125   4.3   CL Chocolate Lily Mt. Douglas
## 31 125   4.3   CL Chocolate Lily Mt. Douglas
## 32 125   4.3   CL Chocolate Lily Mt. Douglas
## 33 125   4.3   CL Chocolate Lily Mt. Douglas
## 11 125   7.2   FL      Fawn Lily Mt. Douglas
## 14 125   7.2   FL      Fawn Lily Mt. Douglas
## 17 125   7.2   FL      Fawn Lily Mt. Douglas
## 15 125   7.2   LF  Licorice Fern Mt. Douglas
## 16 125   7.2   LF  Licorice Fern Mt. Douglas
## 13 125   7.2   ML Miners Lettuce Mt. Douglas
## 18 125   7.2   MF  Monkey Flower Mt. Douglas
## 19 125   7.2   MF  Monkey Flower Mt. Douglas
## 20 125   7.2   MF  Monkey Flower Mt. Douglas
## 21 125   7.2   MF  Monkey Flower Mt. Douglas
## 39 125   4.3       Monkey Flower Mt. Douglas
## 40 125   4.3       Monkey Flower Mt. Douglas
class(exif_sort_name_nona_sort)
## [1] "data.frame"

6 {jsonlite} create json object from no NA’s

exif_json_nona_sortname <- toJSON(exif_sort_name_nona_sort)
exif_json_nona_sortname
## [{"Image":"DSCN7965.JPG","Date":"2022-04-14 14:50:57","Longitude":-123.3453,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7966.JPG","Date":"2022-04-14 14:51:05","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7967.JPG","Date":"2022-04-14 14:51:11","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7968.JPG","Date":"2022-04-14 14:51:13","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7969.JPG","Date":"2022-04-14 14:51:15","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7970 copy.JPG","Date":"2022-04-14 14:51:16","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7970.JPG","Date":"2022-04-14 14:51:16","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7992.JPG","Date":"2022-04-14 14:57:21","Longitude":-123.3456,"Latitude":48.4932,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN7999.JPG","Date":"2022-04-14 14:58:25","Longitude":-123.3457,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8004.JPG","Date":"2022-04-14 14:58:53","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.02,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8005.JPG","Date":"2022-04-14 14:59:07","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8006.JPG","Date":"2022-04-14 14:59:16","Longitude":-123.3456,"Latitude":48.4932,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8007.JPG","Date":"2022-04-14 14:59:17","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN7971.JPG","Date":"2022-04-14 14:52:28","Longitude":-123.3454,"Latitude":48.4929,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7977.JPG","Date":"2022-04-14 14:53:54","Longitude":-123.3454,"Latitude":48.4931,"Exposure":0.0125,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7980.JPG","Date":"2022-04-14 14:54:42","Longitude":-123.3455,"Latitude":48.4931,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7978.JPG","Date":"2022-04-14 14:54:26","Longitude":-123.3455,"Latitude":48.4931,"Exposure":0.002,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"LF","Name":"Licorice Fern","Location":"Mt. Douglas"},{"Image":"DSCN7979.JPG","Date":"2022-04-14 14:54:29","Longitude":-123.3454,"Latitude":48.4931,"Exposure":0.01,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"LF","Name":"Licorice Fern","Location":"Mt. Douglas"},{"Image":"DSCN7975.JPG","Date":"2022-04-14 14:52:41","Longitude":-123.3453,"Latitude":48.4929,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"ML","Name":"Miners Lettuce","Location":"Mt. Douglas"},{"Image":"DSCN7982.JPG","Date":"2022-04-14 14:54:58","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7983.JPG","Date":"2022-04-14 14:55:04","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7984.JPG","Date":"2022-04-14 14:55:09","Longitude":-123.3457,"Latitude":48.4932,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7985.JPG","Date":"2022-04-14 14:55:12","Longitude":-123.3457,"Latitude":48.4932,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN8014.JPG","Date":"2022-04-14 15:02:51","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.001,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN8017.JPG","Date":"2022-04-14 15:03:24","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"Monkey Flower","Location":"Mt. Douglas"}]
class(exif_json_nona_sortname)
## [1] "json"

6.1 save na NA data as json file

copy the text from this file to html file

write(exif_json_nona_sortname, "./data/exif_json_nona_sort.json")

7 HTML file for Leaflet map using json data

<html lang="en">
    <head>
        <title>Leaflet Map - List Reference</title>
        <link rel="icon" href="https://people.geog.uvic.ca/wanthony/website/favicon.png">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta charset="UTF-8">
        <meta name="description" content="Leaflet Map - List Reference">
        <meta name="keywords" content="Leaflet, Map, Test">
        <meta name="author" content="Wendy Anthony">
        <!-- code reference
            https://stackoverflow.com/questions/46302216/leaflet-trigger-event-on-clustered-marker-by-external-element

            https://jsfiddle.net/2gze75L6/6/
         -->
        <link rel="stylesheet" type="text/css" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
        <link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.2.0/leaflet.css"> 
        <link rel="stylesheet" type="text/css" href="https://leaflet.github.io/Leaflet.markercluster/dist/MarkerCluster.Default.css">           
        <link rel="stylesheet" type="text/css" href="https://leaflet.github.io/Leaflet.markercluster/dist/MarkerCluster.css">           
    </head>
    <style type="text/css">
        #map {
            width: 800px;
            height: 1000px;
            border: 1px solid #ccc; 
        }
        #progress {
            display: none;
            position: absolute;
            z-index: 1000;
            left: 400px;
            top: 300px;
            width: 200px;
            height: 20px;
            margin-top: -20px;
            margin-left: -100px;
            background-color: #fff;
            background-color: rgba(255, 255, 255, 0.7);
            border-radius: 4px;
            padding: 2px;
        }
        #progress-bar {
          width: 0;
          height: 100%;
          background-color: #76A6FC;
          border-radius: 4px;
        }

        .prop-div-icon {
          border-radius: 5px;
          background-color: #3a87ad;
          min-width: 50px;
          min-height: 20px;
          font-weight: bold;
          color: white;
          text-align: center;
        }

        .prop-div-icon-shadow {
          top: -3px;
          left: -3px;
          border-radius: 5px;
          background-color: #5bc0de;
          border-color: #3a87ad;
          border: 1px solid;
          min-width: 50px;
          min-height: 20px;
          font-weight: bold;
          color: white;
          text-align: center;
          box-shadow: 3px 3px 3px 0px rgba(125, 125, 125, 0.8);
        }

        .prop-li-item {
          cursor: pointer;
        }
    </style>
<body>
    <div class="container">
        <div class="row">
            <div class="col-md-4">
                <div><h4>Native Plants @ Mt Douglas</h4>
                    <strong>Total Images = <em><span style="font-size: larger;" id="totalData"></span></em></strong>
                </div>
                <div></div>
                <div id="list"></div>
            </div>
            <div class="col-md-8">
                <div id="map" style="max-width: 640px; max-height: 1280px;"></div>              
            </div>
        </div>
    </div>
    <script src="https://code.jquery.com/jquery-2.2.4.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.2.0/leaflet.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/leaflet/1.2.0/leaflet-src.js"></script> 
    <script src="https://leaflet.github.io/Leaflet.markercluster/dist/leaflet.markercluster-src.js"></script>       
    <script type="text/javascript">
        var tiles = L.tileLayer('https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', {
          maxZoom: 15
        });
        var latlng = L.latLng(48.4926, -123.3453);
        var map = L.map('map', {
          center: latlng,
          layers: [tiles]
        });
        var markers = L.markerClusterGroup();
        var markersRef = {};

/* 

>> **** if json data is sorted and doesn't contain any NA values in Name field
>> just copy 

>>> can't use Name that has oppostrophe e.g. Miner's Lettuce s/b Miners Lettuce


json data needs to have a hard return between values
> in json file search for },{ 
> make a hard return, and copy
> add this copied hard return after the , comma
> when copied into this code, the json values must turn yellow (in Sublime)
>>
>>
> each datapoint MUST have a Name
>>
>>
> Description Field is the label shown for marker
>>
 */

        var theDatax = [{"Image":"DSCN7965.JPG","Date":"2022-04-14 14:50:57","Longitude":-123.3453,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7966.JPG","Date":"2022-04-14 14:51:05","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7967.JPG","Date":"2022-04-14 14:51:11","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7968.JPG","Date":"2022-04-14 14:51:13","Longitude":-123.3452,"Latitude":48.4925,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7969.JPG","Date":"2022-04-14 14:51:15","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7970 copy.JPG","Date":"2022-04-14 14:51:16","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7970.JPG","Date":"2022-04-14 14:51:16","Longitude":-123.3452,"Latitude":48.4926,"Exposure":0.0025,"F-Stop":4.9,"ISO":125,"Focal":21.5,"Desc":"BF","Name":"Bee Fly","Location":"Mt. Douglas"},{"Image":"DSCN7992.JPG","Date":"2022-04-14 14:57:21","Longitude":-123.3456,"Latitude":48.4932,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN7999.JPG","Date":"2022-04-14 14:58:25","Longitude":-123.3457,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":5.1,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8004.JPG","Date":"2022-04-14 14:58:53","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.02,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8005.JPG","Date":"2022-04-14 14:59:07","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8006.JPG","Date":"2022-04-14 14:59:16","Longitude":-123.3456,"Latitude":48.4932,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN8007.JPG","Date":"2022-04-14 14:59:17","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"CL","Name":"Chocolate Lily","Location":"Mt. Douglas"},{"Image":"DSCN7971.JPG","Date":"2022-04-14 14:52:28","Longitude":-123.3454,"Latitude":48.4929,"Exposure":0.02,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7977.JPG","Date":"2022-04-14 14:53:54","Longitude":-123.3454,"Latitude":48.4931,"Exposure":0.0125,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7980.JPG","Date":"2022-04-14 14:54:42","Longitude":-123.3455,"Latitude":48.4931,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"FL","Name":"Fawn Lily","Location":"Mt. Douglas"},{"Image":"DSCN7978.JPG","Date":"2022-04-14 14:54:26","Longitude":-123.3455,"Latitude":48.4931,"Exposure":0.002,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"LF","Name":"Licorice Fern","Location":"Mt. Douglas"},{"Image":"DSCN7979.JPG","Date":"2022-04-14 14:54:29","Longitude":-123.3454,"Latitude":48.4931,"Exposure":0.01,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"LF","Name":"Licorice Fern","Location":"Mt. Douglas"},{"Image":"DSCN7975.JPG","Date":"2022-04-14 14:52:41","Longitude":-123.3453,"Latitude":48.4929,"Exposure":0.008,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"ML","Name":"Miners Lettuce","Location":"Mt. Douglas"},{"Image":"DSCN7982.JPG","Date":"2022-04-14 14:54:58","Longitude":-123.3456,"Latitude":48.4931,"Exposure":0.0167,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7983.JPG","Date":"2022-04-14 14:55:04","Longitude":-123.3456,"Latitude":48.493,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7984.JPG","Date":"2022-04-14 14:55:09","Longitude":-123.3457,"Latitude":48.4932,"Exposure":0.0333,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN7985.JPG","Date":"2022-04-14 14:55:12","Longitude":-123.3457,"Latitude":48.4932,"Exposure":0.025,"F-Stop":4.2,"ISO":125,"Focal":7.2,"Desc":"MF","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN8014.JPG","Date":"2022-04-14 15:02:51","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.001,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"Monkey Flower","Location":"Mt. Douglas"},{"Image":"DSCN8017.JPG","Date":"2022-04-14 15:03:24","Longitude":-123.3458,"Latitude":48.4929,"Exposure":0.0008,"F-Stop":2.8,"ISO":125,"Focal":4.3,"Desc":"","Name":"Monkey Flower","Location":"Mt. Douglas"}]


        mapReload();

        function mapReload() {
          // **Clear List**
          var ul = document.getElementById("list");
          ul.innerHTML = '';
          updateMapMarkerResult(theDatax);
          map.fitBounds(markers.getBounds());
        }

        function updateMapMarkerResult(data) {
          markers.clearLayers();
          for (var i = 0; i < data.length; i++) {
            var a = data[i];
            var myIcon = L.divIcon({
              className: 'prop-div-icon',
              html: a.Desc
            });
            var marker = L.marker(new L.LatLng(a.Latitude, a.Longitude), {
              icon: myIcon
            }, {
              title: a.Name
            });
            marker.bindPopup('<div><div class="row"><h5>Name : ' + a.Name + '</h5></div><div class="row"><h5>Date : ' + a.Date + '</h5></div><div class="row">Lat : ' + a.Latitude + '</div><div class="row">Lng : ' + a.Longitude + '</div>' + '<div class="row"><h5>Image: ' + a.Image + '</h5>' + '<img src = "/Volumes/MyPassportForMac/Pictures/!!Nikon-Camera/Nikon-Coolpix-GPS/2022-04-14-MtDouglasPark/' + a.Image + '" style="width:314px; height:239px;"></div>' + '</div>');
            /*
'<div class="row"><img src = "' + Desc + '" style="width:314px; height:239px;"></div>' +
 +
*/
            marker.on('mouseover', function(e) {
              if (this._icon != null) {
                this._icon.classList.remove("prop-div-icon");
                this._icon.classList.add("prop-div-icon-shadow");
              }
            });
            marker.on('mouseout', function(e) {
              if (this._icon != null) {
                this._icon.classList.remove("prop-div-icon-shadow");
                this._icon.classList.add("prop-div-icon");
              }
            });
            markersRef[a.Image] = marker;
            markers.addLayer(marker);

            updateMapListResult(a, i + 1);
          }
          map.addLayer(markers);
        }

        function updateMapListResult(data, totalData) {
          var ul = document.getElementById("list");
          var li = document.createElement("li");
          li.setAttribute('marker', data.Image);
          li.setAttribute('class', 'prop-li-item');
          li.appendChild(document.createTextNode(data.Name));

          // ** Event : Mouse Over **
          li.addEventListener("mouseover", function(e) {
            jQuery(this).addClass("btn-info");
            //markersRef[this.getAttribute('marker')].fire('mouseover'); // --> Trigger Marker Event "mouseover"
            var marker = markersRef[this.getAttribute('marker')];
            _fireEventOnMarkerOrVisibleParentCluster(marker, 'mouseover');
            // TODO : Trigger ClusteredMarker Event "mouseover"
          });
          // ** Event : Mouse Over **
          li.addEventListener("mouseout", function(e) {
            jQuery(this).removeClass("btn-info");
            //markersRef[this.getAttribute('marker')].fire('mouseout'); // --> Trigger Marker Event "mouseout"
            var marker = markersRef[this.getAttribute('marker')];
            _fireEventOnMarkerOrVisibleParentCluster(marker, 'mouseout');
            // TODO : Trigger ClusteredMarker Event "mouseout"
          });
          // ** Event : Click **
          li.addEventListener("click", function(e) {
            markersRef[this.getAttribute('marker')].fire('click');
          });

          ul.appendChild(li);

          var spanTotalData = document.getElementById("totalData");
          spanTotalData.innerHTML = totalData;
        }


        function _fireEventOnMarkerOrVisibleParentCluster(marker, eventName) {
          if (eventName === 'mouseover') {
            var visibleLayer = markers.getVisibleParent(marker);

            if (visibleLayer instanceof L.MarkerCluster) {
                // We want to show a marker that is currently hidden in a cluster.
              // Make sure it will get highlighted once revealed.
              markers.once('spiderfied', function() {
                marker.fire(eventName);
              });
              // Now spiderfy its containing cluster to reveal it.
              // This will automatically unspiderfy other clusters.
              visibleLayer.spiderfy();
            } else {
                // The marker is already visible, unspiderfy other clusters if
              // they do not contain the marker.
                _unspiderfyPreviousClusterIfNotParentOf(marker);
              marker.fire(eventName);
            }
          } else {
            // For mouseout, marker is necessarily unclustered already.
            marker.fire(eventName);
          }
        }

        function _unspiderfyPreviousClusterIfNotParentOf(marker) {
            // Check if there is a currently spiderfied cluster.
          // If so and it does not contain the marker, unspiderfy it.
          var spiderfiedCluster = markers._spiderfied;

          if (
            spiderfiedCluster
            && !_clusterContainsMarker(spiderfiedCluster, marker)
          ) {
            spiderfiedCluster.unspiderfy();
          }
        }

        function _clusterContainsMarker(cluster, marker) {
          var currentLayer = marker;

          while (currentLayer && currentLayer !== cluster) {
            currentLayer = currentLayer.__parent;
          }

          // Say if we found a cluster or nothing.
          return !!currentLayer;
        }
        
    </script>
</body>
</html>

7.1 html leaflet map screenshots

Leaflet Map (screenshot)


Leaflet Map - open (screenshot